Formula to count blank cell isn sheet summary

Question

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 · Answer

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

Tanya Brooks · Answer

Thanks Mark, deleting the empty rows did the trick!

Tanya

Tanya Brooks · Answer

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.