Complicated COUNTIF Formula

Options

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...

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!