COUNTBLANK in Microsoft Excel

The Function of COUNTBLANK in Excel is used to count the number of empty cell  in a group of data coloumn/data row. If we want to count the empty cell from the number of data (include 1 coloumn or 1 row), so this COUNTBLANK can be used for those condition.

Using COUNTBLANK :

=COUNTBLANK(range data)

Example, in a group of data there are a group of number like below :

Then, we will count the empty cell using COUNTBLANK, in formula like below :

From those formula, it means we will count the empty cekk from coloumn D row 2 to coloumn G row 8. And then, we got the result.

usually COUNTBLANK is used to count the number of empty cell from a very huge group of data.

infositeplus.blogspot.com