SUMIF of one column, but need to exclude in the formula if another column = a specific value.

I am trying to get the sum of a specific column but need to exclude an item in the measurement if it equals a specific value from another.

Currently, my formula is:

=COUNTIFS([Project Health]:[Project Health], "Red")

But I need to exclude a specific Project ID in it's measurement and was thinking of doing a <> PROJ01534.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!