Formula to count blank cell isn sheet summary

Tanya Brooks

Hi -

I have countif formulas in my sheet summary that return number of rows in column with a value of "X."

I want to count the number of rows that are blank, that have no value in the cell, and can't figure out the syntax to do that.

Formula being used for counting values is

=COUNTIF([Reim Status]:[Reim Status], "Assigned")

Thanks.

Mark Cronk

HI @Tanya Brooks ,

Try:

=COUNTIFS([Reim Status]:[Reim Status], ISBLANK(@cell)=1)

Work?

Mark

MCorbin

=COUNTIF([Reim Status]:[Reim Status], isblank(@cell))

That should work, but if it's counting the blank rows at the bottom of the sheet, consider using CountIFS and adding a column that always has a value

=COUNTIFS([Reim Status]:[Reim Status], ISBLANK(@cell), [Other Column]:[Other Column], <>"")

Tanya Brooks

Thanks Mark -

That formula at least returned a value! Problem is it is returning a value of 40.

I only have 13 rows and only three have "Reim Status" as blank so I am unlcear what SS is counting.

Tanya Brooks

Thanks Mark, deleting the empty rows did the trick!

Tanya

Mark Cronk

Tanya, As @MCorbin suggested, to get a more reliable answer it would be best to add a range to the COUNTIFS statement that always has a value. Otherwise it will continue to count completely blank rows. You;re using COUNTIFS, so just add a range and criteria like MCorbin's:

=COUNTIFS([Reim Status]:[Reim Status], ISBLANK(@cell)=1, [column that always has a value]:[column that always has a value], <>"")

Glad we could help.

Mark