Sheet Summary Formula for Counting Blank Cells

Melanie PLU

Hi All, I have been playing with this formula for an hour and figured I need to get some help. My formula is below and a screenshot of the page is below that. What do I need to do to get a value other than 0 (which is not accurate)? Thanks for the assistance.

Genevieve P.

Hi @Melanie PLU

I personally find it's easier to use "" in formulas instead of ISBLANK.

Try:

=COUNTIF(STATUS:STATUS, "")

or

=COUNTIF(STATUS:STATUS, @cell = "")

or if you like ISBLANK:

=COUNTIF(STATUS:STATUS, ISBLANK(@cell))

Cheers,

Genevieve