COUNT Function in Excel, Google Sheets, Airtable & Notion
COUNT counts how many of its arguments are numbers. Text, blanks and TRUE/FALSE in a range are not counted; to count non-empty cells of any kind, use COUNTA.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | COUNT(value1, [value2], ...) |
| Google Sheets | ✔ Built in | COUNT(value1, [value2, ...]) |
| Airtable | ✔ Built in | COUNT(number1, [number2, ...])Counts numeric values. In a rollup, COUNT(values) counts linked records with a number in the field; COUNTALL(values) counts every linked record. |
| Notion | ≈ Workaround | list.length()Notion lists from a number property contain only numbers, so prop("Scores").length() counts them. Use .filter(!empty(current)).length() to skip empty values. |
| Excel | =COUNT(A2:A7) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =COUNT(A2:A7) | open sheets.new ↗ |
| Airtable | COUNT(12, "n/a", 7.5, 30, "TBC", 4) | |
| Notion workaround | [12, 7.5, 30, 4].length() |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Value 12 n/a 7.5 30 TBC 4
The Notion list only holds the numbers, as a number property would.
Arguments
| Argument | What it means |
|---|---|
value1 | The first value, cell or range to look at. |
[value2], ... optional | More values or ranges. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=COUNT(A2:A7) | 4 | Tester data: “n/a” and “TBC” are text and not counted. | |
=COUNT(5, "x", 10) | 2 | ||
=COUNT(B:B) | Numbers in column B | A header in B1 is text, so it is not counted. | |
=ROWS(A2:A7) - COUNTA(A2:A7) | Empty cells | Or use COUNTBLANK(A2:A7). |
Examples use Excel / Google Sheets syntax unless noted.
How COUNT works
COUNT is the quickest way to check how many real numbers a range holds. It is also a useful diagnostic: if =COUNT(A2:A100) is lower than you expect, some of those “numbers” are actually text (often from a CSV import) and SUM and AVERAGE are ignoring them. Dates count as numbers; text, blanks, errors and TRUE/FALSE inside a range do not.
The COUNT family covers different questions: COUNTA counts every non-empty cell, COUNTBLANK counts empty cells, COUNTIF counts cells that match a condition, and COUNTIFS handles several conditions.
In Airtable, the Count field type counts linked records, while a rollup with COUNT(values) counts linked records whose field holds a number and COUNTALL(values) counts all of them. Notion has no COUNT; use .length() on a list, or a rollup set to “Count all” or “Count values”.
Frequently Asked Questions
- What is the difference between COUNT and COUNTA?
- COUNT counts only numbers (and dates). COUNTA counts any non-empty cell, including text.
- Why is COUNT lower than the number of rows?
- Some cells are empty or contain text. Numbers stored as text are not counted.