Excel Training: Calculating an Average

Calculating averages in Excel is a common requirement, whether that be average price in a list of products, average time spent on a delivery, or average number of people in a training class.

Here’s a simple guide on how to calculate an average from a list of numbers in Excel. The best way to do this is to use the Excel AVERAGE function.

If you’re familiar with Excel’s SUM function, the Average function works in the same way. For instance, of you would like to display the average figure for the numbers in cells C2 to C5 you need to type “=AVERAGE(C2:C5)” in to the cell where you want this to be displayed and press enter:

excel-training-calcualting-average

An alternative way to do this is to use the AutoSum feature. To do this, select the cell where you would like the average to be displayed and click on the downward arrow next to the AutoSum button on the ribbon. Select “Average” from the list of options:

excel-training-calcualting-average-2

Once you’ve done that =average() will appear in the cell you have selected cell. Now simply highlight the cells that contain the list of numbers you need to calculate the average of – like this:

excel-training-calcualting-average-3

Tags

, , , , , , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

Leave a Comment