# COUNTIFS with OR

✭✭✭

I am trying to solve for a formula to countifs all conditions, except for one that I want to count if either/or:

=COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Range 4}, 0, (OR{HR Projects - PMO Range 7}, "Inclusion & Diversity", "Employee Experience")

Thank you!

• ✭✭✭✭✭✭

Hi Lisa

Try this

=COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Range 4}, 0, {HR Projects - PMO Range 7}, OR(@cell="Inclusion & Diversity", @cell="Employee Experience"))

• ✭✭✭✭✭✭

Hi Lisa

Try this

=COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Range 4}, 0, {HR Projects - PMO Range 7}, OR(@cell="Inclusion & Diversity", @cell="Employee Experience"))

• ✭✭✭

That was SO QUICK and WORKED....THANK YOU!!!!

• ✭✭✭✭✭✭

That was because you were already 99% of the way there. Glad to help with a small tweak.

Kelly

• ✭✭✭✭✭

Hello Kelly,

Wonder if you can figure out why my COUNTIFS is not working??

formula is

=COUNTIFS([22 Jan]@row:[22 Dec]@row, "❌", [22 Jan]@row:[22 Dec]@row, "☢️")

If I only count instances of ❌ my 'COUNTIF' formula works, but when I add the other criteria it doesn't work - returns a '0'.

I'm stumped.

• ✭✭✭✭✭✭

Hey @PeggyLang

Happy to help. Let's see if an OR will help

=COUNTIFS([22 Jan]@row:[22 Dec]@row, OR(@cell="❌", @cell="☢️"))

Does this work for you?

Kelly

• ✭✭✭✭✭

YUP! Works perfectly! I tried the 'OR', however had the syntax WAY off for it to work.

Thank you! Have a greate weekend.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!