/en/excelformulas/relative-and-absolute-cell-references/content/ ## IntroductionA Watch the video below to learn more about using functions in Excel. In order to work correctly, a function must be written a specific way, which is called the ## Working with argumentsArguments can refer to both For example, the function Multiple arguments must be separated by a 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.
## To use a function:In our example below, we'll use a basic function to calculate the - 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 If you want to learn how a function works, you can You can then type an open parenthesis to see ## Understanding nested functionsWhenever a formula contains a function, the function is generally Let's take a look at a more complicated example that uses multiple functions:
Here, we have two different functions working together: the WORKDAY function and the TODAY function. These are known as ## Other common functionsThere are /en/excelformulas/solving-reallife-problems-in-excel/content/
The AVERAGEIF function returns the average of cells in a range that meet criteria you provide. Calculate the average of a group of numbers AVERAGE function AVERAGEIF function
The Let’s determine the average for sales that are greater than $60000. Type an = sign, Don’t type a comma in 60000. Excel would interpret that as a separator for arguments of the function and return an error. And press Enter. Excel automatically adds the closing parenthesis to the formula. The average for sales greater than $60000 is $71229. Let’s walk through this. The function evaluates how many cells in the Sales column meet the criteria of greater than 60000. There are three cells. The function then averages these cells. Now we’ll use the In this example, one range of cells is evaluated against the criteria and a second range of cells is averaged. We type = The average for sales where the number of orders is greater than 50 is $66487. Let’s walk through this one, too. First, the function evaluates which cells in B2 through B5 meet the criteria of greater than 50. Three cells meet the criteria. The function then averages the cells from the Sales column where the criteria is met by the corresponding cell in column B. For more information about the Up next, |