Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells. They are simple functions that go by the names of MIN() and MAX(). This lesson shows you how to use them. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides.

# Learn Excel Formulas and Functions

Excel offers over 300 functions and formulas to help you get more out of your spreadsheets. This page contains a summary of the functions that are covered by lessons on this site. It's being added to all the time, so check back often!

This lesson shows you a way to calculate the number of times a single character occurs in a cell in Excel, and provides a real-life example where I needed to split a column of cells containing part numbers into individual components for each part number.

It can sometimes be useful to know the address of a cell in a worksheet, so you can use that address in a formula. In this lesson, we'll look at how to use the ADDRESS function to find out the address of a cell. We'll then use the ADDRESS function in an example to demonstrate how useful it can be.

If you have a column of numbers and you want to calculate a running total of the numbers alongside, you can use the SUM() formula combined with a clever use of absolute and relative references.

The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the **value of sales** of a **specific product** by a **given sales person** (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.

If you're using Excel to calculate dates, it is useful to know how to add (or subtract) a certain number of working or business days to a date. This lesson introduces the WORKDAY() function and shows you how to use it.

If you're using the Autofilter feature, you're probably wondering how to perform calculations on only those values that are being displayed by the filter. The SUBTOTAL() function is the answer.

The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the **value of sales** of a **specific product** by a **given sales person** (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.

The WORKDAY.INTL() function extends the WORKDAY() function so that you can specify which days are weekend days when adding days to dates. This lesson shows you how to use it.

This lesson shows you now to extract text from a cell in Excel. This is useful when you have a cell containing combining numbers and text, such as a part number, or several text values separated by commas. It introduces the RIGHT() and LEFT() functions, which are essential text manipulation functions in Excel.

## Pages |