How to calculate Average in Microsoft Excel
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.