Google Sheets function
COUNT function in Google Sheets
COUNT in Google Sheets returns how many numeric values appear in the supplied values or ranges. It ignores text, including labels and names, but counts repeated numbers. Use COUNT when you need the number of completed numeric entries rather than the number of every non-empty cell.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=COUNT(value1, [value2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
value1 | Yes | The first value or range to inspect for numbers. |
value2, ... | No | Additional values or ranges to inspect. |
Examples
Count entered scores
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Ava | 84 |
| 3 | Ben | Absent |
| 4 | Cara | 88 |
=COUNT(B2:B4)Result: 2
COUNT includes the two numeric scores and ignores the text entry.
Common mistakes
Using COUNT to count names or other text entries.
Use COUNTA when every value, including text, should count.
Assuming duplicate numbers count only once.
COUNT includes repeated numbers. Use a unique-count approach when duplicates should be removed.