How Do I Do An Average In Excel

So, picture this: I’m helping my buddy Dave organize his fantasy football league stats. He’s got a spreadsheet that looks like a crime scene—numbers everywhere, no labels, and a column that just screams for some order. He looks at me, dead serious, and asks, “How do I even find the average score here?”

I almost laughed. The guy can name every quarterback from 1998, but Excel averages are his kryptonite? It hit me then: even the simplest Excel tricks aren’t obvious until someone shows you. So, let’s be that someone for you today.

Because honestly, finding an average in Excel is like tying your shoes—it feels impossible until you learn the one little loop. After that? You’ll be averaging everything in sight, like a maniac with a calculator.

The Lazy Way: Auto-Average (Your New Best Friend)

You know that sneaky little button in the top-right corner of the Home tab? It looks like a Greek letter (sigma, if you’re fancy). Click the dropdown next to it. See where it says Average? Click that.

Now, just highlight the numbers you want to average. Boom. Excel spits out the result in the cell below your selection. It’s so easy that I feel guilty charging my friends for tech support when I show them this.

One tiny warning: blank cells don’t count, but cells with a zero do count. That’s what my friend Carol learned the hard way when her “perfect” expense report averaged a sad $12. Ouch.

The Manual Method: Typing the Formula (For Control Freaks)

If you’re the type who wants to feel the math in your bones, type it yourself. Click an empty cell and write: =AVERAGE(. Then, either type your numbers separated by commas, or—and this is the pro move—just drag your mouse over the cells you want.

For example: =AVERAGE(B2:B10). That tells Excel to average everything from cell B2 to B10. It’s like giving the robot a very specific grocery list. Close the parenthesis and hit Enter.

You’ll see something like 45.8333. And you’ll think, “I am a spreadsheet wizard.” (You are, by the way. Don’t let anyone tell you otherwise.)

Wait, What About the AVERAGE Function for Rows?

Same deal! If your data runs sideways across row 3, from column A to column G, just write =AVERAGE(A3:G3). Excel is smart enough to read left to right. It’s a team player.

I once used this to average my weekly coffee expenses. I discovered I spend way too much on oat milk lattes. The average didn’t judge me, but I definitely felt the shame.

Troubleshooting the Weird Stuff (Because Excel is a Troll)

Sometimes you’ll get a #DIV/0! error. That’s Excel’s way of saying, “Hey, I tried to divide by zero, and even I know that’s illegal.” Usually, it means your selected cells are all empty. Add some numbers, or check you didn’t accidentally select a header.

Other times, you get a huge decimal like 123.4567. Just click the cell, go to the Number dropdown in the toolbar, and pick “Number” with fewer decimals. Or click the “Decrease Decimal” button until it looks human.

And listen: if your average looks way too high or low, double-check you didn’t include that one cell with “9999” as a fluke. Outliers will wreck your average faster than a toddler wrecks a sandcastle.

The "Average If" Trick (For When Life Gets Complicated)

Now, let’s get slightly spicy. What if you only want the average of sales from last month? That’s where =AVERAGEIF comes in. The syntax goes: =AVERAGEIF(range, criteria, [average_range]).

In plain English: tell Excel which cells to check, what condition to look for, and which numbers to actually average. For example: =AVERAGEIF(A:A, ">100", B:B) averages only the B values where the A column is over 100. It’s like a bouncer for your data.

I used this to find the average rating of only the good movies I watched last year (rating above 7). It made my film taste look surprisingly refined. (Don’t check my other averages.)

One Last Secret: The Status Bar Glance

Before you even type a formula, there’s a cheat code. Just highlight any group of numbers. Look down at the bottom-right corner of your Excel window, at the Status Bar. You’ll see Average, Count, and Sum already calculated for you.

It’s like Excel whispering the answer in your ear before you ask the question. I use this constantly to get a quick vibe check on my totals without making a permanent cell.

So, whether you click the magic button, type a formula like a boss, or just glance at the status bar, you’re now an average-finding pro. Go forth and calculate, my data-driven friend. And maybe help out a Dave sometime.