The mean (or average) of a dataset is one of the most common ways to analyze data. Excel makes it easy. Let’s learn how to find a mean in Excel.
How to Find the Mean in Excel (With AutoSum)
Excel offers at least two quick ways to find the mean. The fastest way comes if your data is in a row or column.
Consider a column of data like this. It has nine unique numbers, and you want to quickly find the average.
To do that, click into the empty cell immediately below the last number. Then, go to the Home tab on Excel’s ribbon. You’ll see the AutoSum button in the Editing group.
Click on the dropdown arrow immediately to the right of AutoSum (if you click AutoSum, the numbers will be added, not averaged).
You’ll see a few options on the dropdown, the second one being Average. Click it, and then highlight your data. Excel will automatically average it for you.
If you’re working with a row of data, the process is identical. Simply click into the empty cell to the immediate right of your last number, and repeat the AutoSum steps.
How to Find the Mean from Multiple Rows and Columns
Imagine now that you have multiple rows or columns, and need to find the mean of numbers within them. This is almost as easy.
Suppose you need to find the average of the numbers in rows 1, 2, 3, and 4. Begin by clicking into an empty cell. Type = to start a formula, then AVERAGE(.
Click and drag to select your data set: in this case, A1:D4. Close the ). Your formula should read:
=AVERAGE(A1:D4)
Hit Enter on your keyboard, and Excel will calculate the average of all the data.
As you can see, Excel makes finding the mean simple. Use these techniques next time you’re analyzing any dataset.