# 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)