Counting Blank Cells

Brittanyy

I need assistance on counting all rows that are blank based upon a status column

The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")).

and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell))

The "Status Blank" is referencing the other sheet.

Nick Korna

If your cells are blank, then this should work:

=COUNTIF({Status Blank}, "")

However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:

=COUNTIFS({Status Blank},"",{Other column}, <>"")

This will count the blank status where there is data in the other column but ignore any blank rows.

Hope this helps, but if you've any questions or problems then just post! 😊