Excel + Google Sheets · COUNTIF
Count anything in one second
Counts how many cells in a range match a value or condition.
The formula
=COUNTIF(B2:B6, "Done")What each part means
B2:B6Where to count"Done"What to count
Example
| A | B | |
|---|---|---|
| 1 | Task | Status |
| 2 | Invoices | Done |
| 3 | Report | Pending |
| 4 | Payroll | Done |
| 5 | Website | Done |
| 6 | Audit | Pending |
| 7 | Done: |
| A | B | |
|---|---|---|
| 1 | Task | Status |
| 2 | Invoices | Done |
| 3 | Report | Pending |
| 4 | Payroll | Done |
| 5 | Website | Done |
| 6 | Audit | Pending |
| 7 | Done: | 3 |
Step by step
- Click cell B7.
- Type the formula:
=COUNTIF(B2:B6, "Done") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)