Excel COUNTBLANK() Function
Excel COUNTBLANK() Function
The COUNTBLANK() function in excel counts the number of blank cells within a range.
Syntax
COUNTBLANK ([value1], [value [2], ...)
Parameter
value1(required)- This parameter represents the first cell in the range.
value2, …(optional)- It represents the second, third, and so on cells in the range.
Category
Statistical
Returns
This function returns the count of the number of blank cells within a range.
Example 1
Objective: To count the number of empty cells in the above table
| List of Numbers | Result | Formula | ||
| 13 | 11 | 50 | 0 | =COUNTBLANK(A18:C18) |
| 191 | A | 1 | 0 | =COUNTBLANK(A19:C19) |
| 82 | 20 | 1 | =COUNTBLANK(A20:C20) | |
| -82.5 | B | 1 | =COUNTBLANK(A21:C21) |
Example 2
| Rows/Columns | B | C | D | E | F |
| 90 | Emp_ID | Employee Name | City/State | Department | Salary |
| 91 | E001 | Beena Singh | New York | Marketing | |
| 92 | E002 | Ritu Sisodia | Sales Executive | ||
| 93 | E003 | Gajni Seth | Texas | $115,550 | |
| 94 | E004 | Ram Nath Kovind | Texas | Customer Support | $99,500 |
| 95 | E005 | Govind | Texas | Customer Support | $35,000 |
Objective: To count the non-empty cells in the data
| Result | Formula |
| 3 | =COUNTBLANK(B90:F95) |