COUNTIFS

I hope you're doing well. I need help with a COUNTIFS Formula. I am trying to plug multiple criteria in an COUNTIFS statement but I'm just getting the value "0" and not the right value. The formula that I am using is:

=COUNTIFS(Status:Status, "Requested", Status:Status, "Demoed", [Automation Category]:[Automation Category], "Data Processing", [Automation Category]:[Automation Category], "Data Visualization", [Automation Category]:[Automation Category], "Robotics", [Automation Category]:[Automation Category], "Workflow")

Would you please be able to help me with this. I have seen many discussions and your responses are always accurate.

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

It looks like you want to count if status is "requested" OR "demoed" and the same for the different options within the [Automation Category] range. If that is the case, try this...

=COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

All comments

Paul Newcome

It looks like you want to count if status is "requested" OR "demoed" and the same for the different options within the [Automation Category] range. If that is the case, try this...

Tahreem Tariq

THANK YOU @Paul Newcome !!!!!

It works!!! Appreciate your help! :))

Have a great day!

Paul Newcome

Happy to help. 👍️

dave.mcpherson56751

Hi Paul

Just found the above and was also a perfect solution for what i was struggling with.

Thanks for posting

Dave

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.