COUNTBLANK
Excel COUNTBLANK Function
Excel has a built-in function called COUNTBLANK that counts the number of blank cells in a range.
The typeface is =COUNTBLANK.
It is useful to use the COUNTBLANK function to locate empty cells within a range.
The =COUNTBLANK function’s usage:
- Select a cell
- Type =COUNTBLANK
- Double click the COUNTBLANK command
- Select a range
- Hit enter
Here are a few illustrations!
Utilize the =COUNTBLANK function on the C2:C21 range to identify the Pokemon without a second type:
COUNTBLANK function, step by step:
- Select C23
- Write =COUNTBLANK
- Double click COUNTBLANK in the menu
- Select range C2:C21
- Hit enter
8 blank cells in the range C2:C21 were successfully tallied using the COUNTBLANK function.
