Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate an average in Excel and Google Sheets
Excel & Google Sheets
=AVERAGE(B2:B100)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Click the cell for the result.
- 2Enter =AVERAGE(B2:B100), selecting the numbers to average.
- 3Empty cells are ignored, so the mean is not skewed by blanks.
Tips
- To average only some rows, use AVERAGEIF, e.g. =AVERAGEIF(A:A, "West", B:B).
- Blank cells are skipped, but a cell containing 0 is included in the average.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Does AVERAGE count blank cells as zero?
No. AVERAGE ignores truly empty cells. A cell that contains 0, however, is counted.