How do I exclude values from a COUNTIFS expression?

PKane ✭✭✭✭
edited 12/29/22 in Formulas and Functions

Hello All,

I am hoping someone can help me figure out - how do I get my formula to exclude specific status items from its count?

I am pretty new to formulas -

I would like my formula to count the number of statuses by type - and exclude any that are 'Cancelled' or 'Complete'

Here is what I have so far - I tried various things but haven't had any luck.

=COUNTIFS({Remediations Category}, "Other-Fac-Bldg", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2021", {Remediations Status}, <>"Complete", {Remediations Status} <> "Cancelled")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!