Count "text" if the status is "Doing"

I'd like a way to count Theme column (Text Column) if "IVR" appears, AND if the Status Column (Dropdown column) is either "Backlog" or "To Do" or "Doing"

I can get a simple countif formula to work, but can't figure out how to add a second criteria based on status

i tried ones along the lines of

=COUNTIF(AND(Theme:Theme, "IVR"), IF(Status:Status, "Doing"))

=COUNTIFS(Theme:Theme, ="IVR", Status:Status, ="To Do", "Doing", "Backlog")

Find more posts tagged with

Formulas

functionality

Accepted answers

@SPark

I'm sure there is a more eloquent/simplified way of doing this AND if I understood your question correctly-- here is what I came up with.

=SUM(COUNTIFS(Theme:Theme, "IVR", Status:Status, "Backlog"), COUNTIFS(Theme:Theme, "IVR", Status:Status, "To Do"), COUNTIFS(Theme:Theme, "IVR", Status:Status, "Doing"))

Angela Ryer

Yes, thank you. Using yours as a base, I was able to tweak it a bit and remove each "Theme:Theme, "IVR" section; still have it work.

=SUM(COUNTIFS(Theme:Theme, "IVR", Status:Status, "Backlog"), COUNTIFS(Status:Status, "To Do"), COUNTIFS(Status:Status, "Doing"))

Then that got me thinking further to attempt to simplify it with @cell - which worked as well

=COUNTIFS(Theme:Theme, "IVR", Status:Status, OR(@cell = "Backlog", @cell = "To Do", @cell = "Doing"))

Thanks much; What you came up with helped me have a jumping off point. I was going in circles before.

All comments

@SPark

I'm sure there is a more eloquent/simplified way of doing this AND if I understood your question correctly-- here is what I came up with.

=SUM(COUNTIFS(Theme:Theme, "IVR", Status:Status, "Backlog"), COUNTIFS(Theme:Theme, "IVR", Status:Status, "To Do"), COUNTIFS(Theme:Theme, "IVR", Status:Status, "Doing"))

Angela Ryer

Yes, thank you. Using yours as a base, I was able to tweak it a bit and remove each "Theme:Theme, "IVR" section; still have it work.

=SUM(COUNTIFS(Theme:Theme, "IVR", Status:Status, "Backlog"), COUNTIFS(Status:Status, "To Do"), COUNTIFS(Status:Status, "Doing"))

Then that got me thinking further to attempt to simplify it with @cell - which worked as well

=COUNTIFS(Theme:Theme, "IVR", Status:Status, OR(@cell = "Backlog", @cell = "To Do", @cell = "Doing"))

Thanks much; What you came up with helped me have a jumping off point. I was going in circles before.

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.