COUNTBLANK function

Use

The COUNTBLANK function is the Statistical function, which is used to count the number of blank cells in a range of cells.

Syntax

=COUNTBLANK(range) where,

(range) – The cell range from which you want to count the blank cells.

Example

1- Type =COUNTBLANK in your desired cell and select cell range A4:A9.

 2- Excel will count all blank cells from the selected range.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved