Complicated COUNTIF Formula
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:
- If the value in Column 6 does NOT occur in "Status Range 6", enter a blank
- 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
- 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...
Best Answer
-
Try moving the closing parenthesis after zero to before the =.
Answers
-
Try moving the closing parenthesis after zero to before the =.
-
Wow! That worked. But how?! :)
Thanks so much!
-
Ah. Never mind. I see. Rookie mistake...which is ok because I'm a rookie. Thanks again!!!
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!