Situatie
There are four AVERAGE functions and each has different uses:
- AVERAGE: This produces the arithmetic mean (the sum of all numbers divided by the number of values) of a set of data, ignoring anything that isn’t a number.
- AVERAGEA: This returns the mean of a set of numbers, text, and logical arguments.
- AVERAGEIF: This calculates the arithmetic mean of a set of numerical data that fulfill a single criterion.
- AVERAGEIFS: This tells you the arithmetic mean of a set of numerical data that fulfill several criteria.
Solutie
To calculate the average in Excel, use the following syntax:
=AVERAGE(A,B)
where A is the first number, cell reference, or range, and B is up to a maximum of 255 additional numbers, cell references, or ranges to include in the average calculation.
In this example, we have a set of seven students and want to calculate their average exam score.
As you can see, Student C scored 0 and Student F has yet to take the exam. As a result, we want Excel to work out the scores of those who have taken the exam (all students except for Student F).
To do this, we would type the following formula into cell D2:
=AVERAGE(B2:B8)
The AVERAGE function includes 0 within its calculations but ignores all empty cells, text, and logical values (TRUE or FALSE). So, we can be confident that this calculation will include Student C’s score, but ignore Student F’s score.
If any of the values being used in the AVERAGE calculation were to contain one of Excel’s formula errors, the calculation would not work.
TIP
To save time, you can instead calculate the average through a few simple clicks. First, select your data to average, click the “Home” tab on the ribbon, and in the “Editing” group, click on the drop-down arrow next to the sigma (Σ) symbol. From there, click “Average”. The result will appear at the end of your data.
Leave A Comment?