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.
How to Calculate Average Numbers in Excel (9 Handy Methods)
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.
