AVERAGE adds the numeric values in its arguments and divides by how many numbers there were. Blank cells and text are skipped entirely while zeros are counted — a missing score should not drag the mean down, but a recorded zero should. With no numbers left it returns #DIV/0!.
Returns a number. Blanks and text in ranges are ignored; zeros are counted. No numbers gives #DIV/0!.
A range with a blank and a text cell, measured live. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =AVERAGE(A2:A6) | 72 | Mean of five scores |
| =AVERAGE(B2:B6) | 1110 | Mean of five sales |
| =AVERAGE(A2:A8) | 72 | Blank and text ignored |
| =AVERAGE(85,92,78) | 85 | Direct numbers |
| =AVERAGE(A2:A4) | 85 | First three scores |
| =ROUND(AVERAGE(B2:B8),2) | 978.57 | All sales to 2 dp |
| =ROUND(AVERAGE(A2,A4,A6),2) | 69.33 | Selected cells |
| =AVERAGEIF(C2:C8,"West",A2:A8) | 76 | Conditional mean (West) |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see how blanks, text and zeros change the mean.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
AVERAGE is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
AVERAGE is one piece. The full course walks the toolkit end to end with live, measured examples.