Complicated COUNTIF Formula

Mike D.

I finally got my formula right to count based on certain criteria but now I'm trying to figure out how to get it to enter a blank instead of a zero:

=IF(COUNTIF({Status Range 6}, [Column 6]@row = 0), "", COUNTIFS({Status Range 6}, [Column 6]@row, {Status Range 3}, @cell <> "New Configuration"))

What I'm trying to do specifically is this:

1. If the value in Column 6 does NOT occur in "Status Range 6", enter a blank
2. If the value in Column 6 does occur in "Status Range 6" but the value on that row in "Status Range 3" is "New Configuration", then enter a blank
3. If the value in Column 6 does occur in "Status Range 6" and the number of times the value in Column 6 occurs in "Status Range 6" AND the value on that row in "Status Range 3" is NOT "New Configuration", then count the number of times it occurs.

The formula that I wrote above seems to work except I'm getting zeros instead of blanks...

Paul Newcome

Try moving the closing parenthesis after zero to before the =.

Paul Newcome

Try moving the closing parenthesis after zero to before the =.

Mike D.

Wow! That worked. But how?! :)

Thanks so much!

Mike D.

Ah. Never mind. I see. Rookie mistake...which is ok because I'm a rookie. Thanks again!!!

Paul Newcome

Happy to help. 👍️