AVERAGE (Arithmetic Mean)

Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up a list of numbers and divide by sum of inputs. Below we will walk through the basics of this process.

Various AVERAGE Syntax’s available in Excel:

=AVERAGE – returns an average of numbers.

=AVERAGEIF – finds an average of numbers based on a single criterion.

=AVERAGEIFS – finds an average of numbers based on multiple criteria.


In the example, we use the syntax:


This gives us the result of 19.125


Leave a Reply

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to

Read More »
Scroll to Top