About this lesson
Counting things in Google Sheets: COUNT, COUNTA, COUNTBLANK
In Google Sheets, =COUNT(C2:C16) counts cells holding numbers, =COUNTA(C2:C16) counts every cell that isn't empty (text included) and =COUNTBLANK(C2:C16) counts the empty ones. So COUNTA − COUNT is the number of text entries.
Using Excel? Do this lesson in Excel.
=COUNTA(A2:A16)What you'll practise
Track debtor confirmations on a Big 4 audit: how many went out, how many came back with an amount, how many are still unanswered, and the response rate.
4 steps · 40 points · the cells outlined in gold below
- COUNT
- COUNTA
- COUNTBLANK
- response rate
The data
| A | B | C | |
|---|---|---|---|
| 1 | Customer | Ledger ($) | Confirmed ($) |
| 2 | Coastal Civil Works | 284,610 | 284,610 |
| 3 | Redgum Earthmoving | 156,240 | 156,240 |
| 4 | Bluegum Fabrication | 97,385 | Disputed |
| 5 | Tasman Steel Erectors | 412,870 | 412,870 |
| 6 | Kestrel Mining Services | 63,915 | |
| 7 | Gidgee Construction | 228,450 | 228,450 |
| 8 | Mulga Plant Hire | 41,780 | 41,280 |
| 9 | Saltwater Marine | 175,320 | |
| 10 | Ironstone Developments | 319,060 | 319,060 |
| 11 | Paperbark Homes | 88,145 | Disputed |
| 12 | Bunya Infrastructure | 502,330 | 502,330 |
| 13 | Stringybark Rail | 134,675 | |
| 14 | Galah Logistics | 72,990 | 72,990 |
| 15 | Spinifex Resources | 246,505 | 246,505 |
| 16 | Quoll Engineering | 118,260 | |
| 17 | |||
| 18 | Confirmations sent | ||
| 19 | Confirmed with an amount | ||
| 20 | No reply yet | ||
| 21 | Response rate |