COUNTIFS Using "OR"
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?
Best Answers
-
You could add the two together.
=COUNTIFS(.....) + COUNTIFS(.....)
=COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Area FY23}, "East") + COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Manager}, "Schoch, Marcus")
-
Happy to help. 👍️
Answers
-
You could add the two together.
=COUNTIFS(.....) + COUNTIFS(.....)
=COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Area FY23}, "East") + COUNTIFS({NST2023Role}, "Sr. Dean", {NSTStatus}, "Invited", {Manager}, "Schoch, Marcus")
-
Yes! I think that worked! Thank you so very much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!