COUNT tells you how many of its arguments are numbers. In a range it counts numeric cells and skips text and blanks — the right tool for 'how many responses did we actually get?'. COUNTA counts anything non-empty and COUNTBLANK counts empties; confusing the three is the most common counting mistake.
Returns a number. Counts numeric cells and numeric literals; text and blanks in ranges are ignored.
5 numbers + 1 blank + 1 text, read three ways, measured live. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =COUNT(A2:A6) | 5 | Five numeric scores |
| =COUNT(A2:A8) | 5 | Blank and text ignored |
| =COUNTA(A2:A8) | 6 | Counts the text cell too |
| =COUNT(B2:B8) | 7 | All seven sales numeric |
| =COUNT(85,"text",92) | 2 | Typed text ignored |
| =COUNT(A2:A4) | 3 | First three scores |
| =COUNTBLANK(A2:A8) | 1 | One blank cell |
| =COUNT(C2:C8) | 0 | All-text range |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare COUNT, COUNTA and COUNTBLANK.
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.
COUNT is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
COUNT is one piece. The full course walks the toolkit end to end with live, measured examples.