• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Mean in Excel

March 22, 2021 by Andrew Childress
Excel find mean autosum results

The mean (or average) of a dataset is one of the most common ways to analyze data. Let's learn how to find a mean in Excel.

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.

Find mean in Excel updated

 

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).

Find mean Excel dropdown

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.

Excel find mean autosum results

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)

How to find average in Excel

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.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Remove blank rows in Microsoft ExcelRemove Blank Rows in Excel
Next Post:Spell Check in ExcelHow to use spell check in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top