Countifs, is not blank question??

TDobson

I have a formula that counts distinct entry's in a column "IFS Service Location" (to avoid counting duplicates) and in the "booking status" column had a status of "ready to book". .

=COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Booking Status}, "Ready to Book")))

I would like to change the citerion_range1 to a different column called "incentive date" and count the non blank cells in that column.

=COUNTIFS(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))) (unparseable)

It does not work yet. Am I on the right track? Any suggestion would be appreciated.

TDobson

Here is a snipit of the 2 columns. The Incentive Date column is a date column.

Genevieve P.

Hi @TDobson

It looks like you just have an extra closing parentheses!

=COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Incentive Date}, <>"" )))

You only need three ))) one for COUNT, one for DISTINCT, one for COLLECT. Let me know if updating the COUNTIFS to COUNT and removing one ) from the end works for you.

Cheers,

Genevieve