Nested Ifs

I need and if statement on a metric sheet that counts if 3 criteria are met.

If one column = this

If another column = that

If last column = "No"

This is what I have and I though it might work but I get the #UNPARSEABLE error.

=COUNTIFS({Range 1}, [Primary Column]3, FIND(AND({Range 3} = [Primary Column]9, {Range 2} "No")))

I also tried

=If{Range 1} = [Primary Column]3, Count({Range 1}), If(Range 2 = "No", Count({Range 1}), If({Range 3} = [Primary Column]9, Count({Range 1}, " ")))

I got the same error.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!