How To Find Average In Excel

So, you’ve got a bunch of numbers staring back at you from an Excel spreadsheet, and you need to know the average. Maybe you’re splitting a dinner bill, calculating your final grade, or just trying to figure out how many cups of coffee you really drink per week. Don’t panic—Excel makes this so easy, you’ll feel like a math wizard without ever touching a calculator.

The Magic Button: AutoSum

The absolute easiest way to find an average in Excel is by using the AutoSum button. It’s like the lazy genius of the spreadsheet world.

Click on an empty cell right below (or to the side of) your list of numbers. Then, look for the Home tab at the top and find the button that says AutoSum—it looks like a Greek letter E (Σ). Click the little arrow next to it, and select Average.

Excel will magically guess which numbers you want to average. Hit Enter, and boom—your result appears. No sweat, no equations, no friend asking you for math help at 2 AM.

The Quick Fix: Status Bar Check

Wait, what if you just need a quick peek at the average without even typing anything? Excel has your back here too.

Simply highlight all the numbers you’re curious about. Then, glance down at the bottom-right corner of your Excel window—that’s the status bar. You’ll see the Average, Count, and Sum pop up automatically.

It’s like Excel is reading your mind, but without the creepy sci-fi vibes. Try it next time you’re comparing avocado prices. Who knew grocery math could be this painless?

The Classic Command: AVERAGE Formula

If you want to feel a little more like a pro, or if AutoSum just isn’t your style, you can type the formula yourself. It’s still super simple.

Click any empty cell and type this exactly: =AVERAGE(. Then, highlight the cells with your numbers—like A1 through A10—and close the parenthesis. It should look like =AVERAGE(A1:A10).

Hit Enter, and you’ll see the average appear. That’s it. No rocket science, no complicated drop-down menus, just you and a very obedient spreadsheet. High-five your keyboard if you feel fancy.

What About Blanks or Zeros?

Here’s the thing: Excel is smart, but it’s not a mind reader. If you have empty cells in your list, the AVERAGE function ignores them. Great for skipping lazy Sunday data.

But if you have a cell with zero typed in it? Excel counts that as a number. So a zero will drag your average down—just like that one person in a group project who did nothing. Be careful with your zeros.

If you want to ignore zeros too, you’ll need the AVERAGEIF function—but that’s a story for another day. For now, just remember: blanks are ghosts, zeros are real.

Average of Non-Adjacent Cells

What if your numbers are scattered all over the spreadsheet? Like your scores from five different tabs of chaos? No worries—you can still average them without pulling your hair out.

Type =AVERAGE( again, then hold down the Ctrl key (Command on a Mac) while clicking each cell you want to include. Click cell B2, then F7, then D4—whatever you need.

When you’re done, close the parenthesis and hit Enter. Excel will figure out the average of that random collection. It’s like herding cats, but the cats actually listen. Miracle, right?

Average with Criteria (AVERAGEIF)

If you’re feeling adventurous, Excel lets you average only the numbers that meet a certain condition. For example, “average my sales, but only for products with ‘coffee’ in the name.” That’s a job for AVERAGEIF.

Type =AVERAGEIF(. Then select the range you want to check, add a comma, put the condition in quotes (like “>10” or “Yoga”), add another comma, and select the actual numbers to average. It sounds complex, but it’s basically telling Excel, “Hey, be picky, please.”

You don’t need to master this today. Just know it exists, like that secret menu item you order when you’re feeling bold. You’re growing up so fast!

Common Mistakes (And How to Laugh Them Off)

You might accidentally type =average with a lowercase “a”—Excel doesn’t care, it’s case-insensitive. Phew. But if you forget the equal sign, Excel will treat it as text. You’ll just see the word “AVERAGE” staring at you like a judgmental cat.

Another classic goof: selecting the whole column (like A:A) when you only have a few numbers. That’s fine—Excel just ignores the empty cells. But it’s a bit like ordering a full pizza when you only want one slice. You can do it, but why?

If you accidentally include a cell with text in your range, Excel might throw a #DIV/0! error. That’s Excel’s way of saying, “I can’t divide by zero, and also, please stop putting ‘banana’ in your number list.” Just remove the text, and you’re back in business.

Why Bother Learning This?

Because averages are everywhere. They help you find the typical tip amount, the usual commute time, or the average number of times you hit snooze (don’t judge). Once you know this trick, you’ll start averaging everything for fun.

You’ll impress your boss, help your friends with their budgets, and feel a spark of joy every time you see that number appear. Excel is basically a friend who never steals your lunch.

And if you ever mess up? That’s okay—just hit Undo (Ctrl+Z) and try again. Mistakes are just practice in disguise.

So go ahead, open that spreadsheet, select your numbers, and let Excel do the heavy lifting. You’ve got this. And remember: an average is just a way to say, “Hey, life is a mix of highs and lows, but here’s the middle ground.” You’re already above average for learning this. Now go spread that spreadsheet joy!