How do I use COUNTBLANK in Excel?
Use COUNTBLANK when you want to count blank cells. Enter Range in that order, then add optional arguments when needed.
Excel Function
COUNTBLANK
Counts blank cells in a range.
COUNTBLANK(range)Arguments
range
RequiredSpecify the range used for condition check or aggregation.
Practice Preview
Use COUNTBLANK to count blank cells in Sales in column D.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=COUNTBLANK(D2:D8)Result
2
Practice This Function
COUNTBLANK FAQ
Where can I practice COUNTBLANK?
Use the "Start Function Practice" button to jump straight into COUNTBLANK drills.
What arguments does COUNTBLANK use?
The main arguments are Range. Enter them in order.