Practice challenge
Count active customer IDs
#25
3 attempts remaining
BeginnerCustomersTarget C2
A customer list has blank rows for inactive slots.
Write a formula for C2 that counts filled customer IDs in A2:A6.
Count active customer IDs
Swipe horizontally to view the full table.
| A | B | C | |
|---|---|---|---|
| # | Customer ID | Name | Active IDs |
| 2 | C-104 | River Co | blank |
| 3 | C-205 | North Ltd | blank |
| 4 | blank | blank | blank |
| 5 | C-310 | Blue Shop | blank |
| 6 | C-422 | Metro Inc | blank |