Excel Function: COUNTBLANK

The Excel function COUNTBLANK is used to determine the number of empty cells.



Example of use

The goal here is to get the total number of members who have not made any donations by counting the empty cells:

excel function countblank

Select the COUNTBLANK function and then simply enter the range of cells in which to count the number of empty cells:


countblank function png

Click OK to get the result: