Get UNSTUCK with Expert Advice

Press Esc to close

The Excel Average() function

The average() function is very similar to the sum() function: it receives a range of cells, and returns the average of all the numbers that appear in that range (i.e. the sum of all the cells divided by the number of cells).

The following sheet contains a list of kinder-garden kids and their height:

The following formula will show us the average height of the entire kinder-garden population:

=AVERAGE(B2:B16)

As shown here...

previous

next

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us