Excel like a finance pro.
The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.
COUNT / COUNTA / COUNTBLANK
AggregationAnswer 'how many?' — numbers only, anything at all, or the empty ones.
Difficulty
1What is it?
This trio counts cells three ways. COUNT counts only the cells that hold a number (dates count, since they're numbers underneath). COUNTA counts every non-empty cell — numbers, text, errors, anything. COUNTBLANK counts the empty ones. The distinction matters constantly: COUNT tells you how many rows have a value entered, COUNTA tells you how many rows are filled at all, and mixing them up is a classic source of an off-by-a-few count.
2What it looks like
COUNTA(value1, [value2], …)- value1
- The first range to count.
- [value2], …
- Optional more ranges.
3When you use it
- Count how many rows are filled in a list: COUNTA(A2:A1000).
- Count how many cells actually hold a number: COUNT(B2:B1000).
- Find gaps in a column with COUNTBLANK.
4See it in action
Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.
The same column, counted three ways. Switch the function and watch the answer change — the column mixes a number, text, and a blank.
=COUNT(B2:B6)2| A | B | C | |
|---|---|---|---|
| 1 | Row | Value | Result |
| 2 | 1 | 120 | 2 |
| 3 | 2 | Pending | |
| 4 | 3 | ||
| 5 | 4 | 340 | |
| 6 | 5 | Pending |
The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.
5Common errors
Count is too lowYou used COUNT on a column of text (names, statuses).Fix: COUNT only counts numbers — use COUNTA to count text entries too.
Blank isn't blankCOUNTBLANK counts a cell, but COUNTA does too — a formula returning "".Fix: A formula result of "" looks empty but isn't truly blank; clear the cell or count differently.
Counting the headerThe range includes the header row.Fix: Start the range on the first data row (A2, not A1).
6Better functions & alternatives
- COUNTIFS — Count only the rows that meet conditions.
- SUBTOTAL(3, …) — Count just the visible rows after filtering.
- COUNTUNIQUE via UNIQUE — Count distinct values with COUNTA(UNIQUE(range)).
Want COUNT / COUNTA / COUNTBLANK already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.
Learn the moves here — or let Wauvel run them on your numbers.
Get my free report →