Counting Blank Cells

Brittanyy · 09/01/23

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 · 09/04/23

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! 😊

Nick Korna · 09/04/23

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! 😊

Kaveri Vipat · 09/04/23

Hi Brittanyy,

Please try the following formula, ‘Status blank’ is the range you are referring to from the other sheet, and “” is for finding all the blank cells in the range.

=COUNTIF({Status Blank}, "")

NickBlocker · 12/18/23

Hi There SS Gurus!

I am having a similar issue. I have blank cells I would like to count however; the formula is returning #UNPARSEABLE

=COUNTIF([Assigned To]:[AssignedTo], "")

Andrée Starå · 12/18/23

Hi @NickBlocker

I hope you're well and safe!

Try something like this.

=COUNTIF([Assigned To]:[Assigned To], "")

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

NickBlocker · 12/19/23

@Andrée Starå - That worked! I have no idea what happened yesterday as that is the formula i was using but gave me the ##UNPARSEABLE however; this morning its working........

I appreciate your quick response and solution!

Andrée Starå · 12/19/23

@NickBlocker

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Counting Blank Cells

Best Answer

Answers

Help Article Resources

Categories