When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.

There are a variety of functions. Here are some of the most common functions you'll use:

**SUM**: This function**adds**all the values of the cells in the argument.**AVERAGE**: This function determines the**average**of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.**COUNT**: This function**counts**the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.**MAX**: This function determines the**highest****cell value**included in the argument.**MIN**: This function determines the**lowest cell value**included in the argument.

In our example below, we'll use a basic function to calculate the **average price** **per unit **for a list of recently ordered items using the AVERAGE function.

- Select the
**cell**that will contain the function. In our example, we'll select cell**C11**. - Type the
**equals sign (=)**and enter the desired**function name**. In our example, we'll type**=AVERAGE**. - Enter the
**cell range**for the**argument**inside**parentheses**. In our example, we'll type**(C3:C10)**. This formula will add the values of cells C3:C10 and then divide that value by the total number of cells in the range to determine the average. - Press
**Enter**on your keyboard. The function will be**calculated**, and the**result**will appear in the cell. In our example, the average price per unit of items ordered was**$15.93**.

Your spreadsheet **will not always tell you** if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, check out the Double-Check Your Formulas lesson.