How To Use Excel Average Function

Average c3 e3 at each new row average calculates an average of the quiz scores for each person.

How to use excel average function. This formula is categorized as a statistical function. To do this click in the cell where you want to use the average function. Calculate average in excel. The average function in excel gives the arithmetic mean of the supplied set of numeric values. The average function in excel calculates the average arithmetic mean of a group of numbers.

Then click the drop down arrow just to the right of the autosum button. This article describes the formula syntax and usage of the average function in microsoft excel. The average function is categorized under statistical functions. It is used to calculate the arithmetic mean of a given set of arguments. From the list of options that pops up choose average.

The syntax of the average function is. A number of the range of numbers for which the average is calculated. The average range argument is optional. Number2 to number 255 optional is the additional data you want to include in the average calculation. Click the insert function button fx under formula toolbar a dialog box will appear type the keyword average in the search for a function box an average function will appear in select a function box.

It will return the average of the arguments. Double click on average function. For example the average function below calculates the average of the numbers in cells a1 through a3. In excel average function is one of the statistical and most commonly used functions. As a financial analyst the function is useful in finding out the average of numbers.

Criteria can be supplied as numbers strings or references. Averageif calculates the average of the numbers in a range that meet supplied criteria. Number1 required is the data from which you want the function to find the average. Below is the average formula. Instead of using the average function use sum and count.