Basic Microsoft Excel Functions: AVERAGE

Another basic, yet powerful, Excel function is AVERAGE

It does exactly what you would expect it to; gives you the average of a range of numbers.

Download the accompanying file(s) for this article.

This is very useful and powerful if you have a large dataset and you need to know the average result quickly.



For example, look at the data below, are you able TO quickly calculate the average just by looking at it? Probably not

Average Data
Average Data

Move to cell B1 and type in =AVERAGE(A2:A40) and press enter.


The formula instantly returns the average value of the cells in the selected range.

The formula will also keep updating as the values change, as long as the values stay within the A2:40 range. You can work around that limitation by using range names, an article on that topic will follow later.

Try changing the values in some of the cells and watch the average value instantly change.


What if you want to know the average value but don’t need it displayed on the spreadsheet? Highlight all the data and look at the bottom right hand corner of your Excel window. Excel displays (depending on your configuration) the average, sum and count of the data which you have highlighted.

If you cannot see these numbers right-click on the bottom bar and select the calculation you want to see from the menu

Select calculations to show
Select calculations to show

A quick, simple and easy formula that can be very useful!

If you’ve found this article interesting and or useful please share it on social media using the handy share buttons

Subscribe to our mailing list to be the first to know when new articles are published

At Happy Duck we build bespoke business and financial management tools for small, medium and large companies that help them achieve their goals. This makes us happy. Find out more about us and about our services.

More in Excel Basics


Leave a comment

Your e-mail address will not be published. Required fields are marked *