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.
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
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
A quick, simple and easy formula that can be very useful!