Countifs with AND/OR

chadedwardconway ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi There

I have a Countifs that is counting the number of projects that are healthy (Green), marked as "prioritized", are "in progress" and match a particular category. This works great, except I'm trying to expand this to look for "in progress" projects OR "not started" projects, but maintain all the other AND criteria..

I can't quite figure out how to fit the OR statement into my formula--Would love some recommendations.

This is the formula that I have written:

=COUNTIFS({Master Project List - Project Health}, "Green", {Master Project List - Prioritization}, "Prioritized", {Master Project List - Project Status}, "In Progress", {Master Project List - Category}, Category@row)


Thank you for any tips!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!