Syntax
=COUNT(value1, [value2, ...])
value1- A cell, range or value to count.
value2, ...- Optional. More ranges or values.
COUNT function in Google Sheets
COUNT tells you how many cells contain numbers. It ignores text and blanks, which makes it useful for counting how many entries have actually been filled in with a value.
Practice COUNT
Task 1 of 1
Some days are marked "Sick" or "PTO" instead of hours. Count how many days have actual hours logged (numbers) in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
COUNT examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Class | Score | Passed |
| 2 | Priya | A | 92 | TRUE |
| 3 | Leo | B | 67 | FALSE |
| 4 | Chloe | A | 48 | FALSE |
| 5 | Mateo | B | 81 | TRUE |
| 6 | Ines | C | FALSE | |
| 7 | Kai | C | 75 | TRUE |
| Formula | Result | What it shows |
|---|---|---|
=COUNT(C2:C7) | 5 | Scores entered (the blank is not counted). |
=COUNT(A2:A7) | 0 | Names are text, so COUNT finds none. |
=COUNT(A1:D7) | 5 | Only the score cells in the whole table are numbers. |
Tips and common mistakes
- To count cells containing anything at all (including text), use COUNTA.
- To count only cells that match a condition, use COUNTIF or COUNTIFS.
- TRUE/FALSE values in a range are not counted.
Related functions
Learning step by step? COUNT is covered in Lesson 5: COUNT, COUNTA & COUNTBLANK of the free course.