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.
Help Article Resources
Check out the Formula Handbook template!