Count cells that are blank

Use the COUNTBLANK function to count cells that are blank. In our example, the formula used is:

=COUNTBLANK(A4:A9)

where,

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

Example

Formula:

Result:

How to count non-empty cells?

Use the COUNTA function to count non-empty cells from a selected range.

Formula:

Result:

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