COUNTIFS Using "OR"

Sarah De Silva
edited 10/24/22 in Formulas and Functions

Hello! I have two working formulas that counts my company's personnel based on specific criteria, but I'd like to use them in the same cell so that data is gathered if either of them are true. Here are the separate formulas:

=COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Area FY23}, "East")

=COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Manager}, "Schoch, Marcus")

Each of these formulas correctly pull the information that I want. I tried to put them together using "OR" and then I get an error message. Is there a way to have something counted if EITHER of the formulas above are true?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!