Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inCOUNT(value1, [value2], ...)
Google Sheets✔ Built inCOUNT(value1, [value2, ...])
Airtable✔ Built inCOUNT(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≈ Workaroundlist.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.
Try COUNT with your own values
Mix numbers and text to see what is counted
Result (as Excel & Google Sheets return it)
4
Your formula, ready to paste
Excel=COUNT(A2:A7) open excel.new ↗
Google Sheets=COUNT(A2:A7) open sheets.new ↗
AirtableCOUNT(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

ArgumentWhat it means
value1The first value, cell or range to look at.
[value2], ... optionalMore values or ranges.

Examples

FormulaResultWhyCopy
=COUNT(A2:A7)4Tester data: “n/a” and “TBC” are text and not counted.
=COUNT(5, "x", 10)2
=COUNT(B:B)Numbers in column BA header in B1 is text, so it is not counted.
=ROWS(A2:A7) - COUNTA(A2:A7)Empty cellsOr 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.

Part of the Statistics & Counting functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.