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?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

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")

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

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")

Sarah De Silva

Yes! I think that worked! Thank you so very much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.