Need help with COUNTIFS formula

I am trying to get a COUNTIFS formula to only count values in column "Status" that contain "To-Do" or "In Progress" where the "Days Aged" column is greater than 14 but less than 31.

This is the formula I am using

=COUNTIFS(Status:Status, "To-Do", [Status]:[Status], "In Progress", [Days Aged]:[Days Aged], >14, [Days Aged]:[Days Aged], <31)

But the value in the Sheet Summary return with 0, but I can see in my sheet that there are various rows that are within this.

I have attached a snippet of my Sheet

Any help on this would be much appreciated

Find more posts tagged with

Accepted answers

SavvyAdam

I was able to get this to work going the other way, by adding exclusions instead of inclusions.

This is what I used

=COUNTIFS(Status:Status, <>"Closed", Status:Status, <>"Cancelled", [Days Aged]:[Days Aged], > 14, [Days Aged]:[Days Aged], < 31)

All comments

Nic Larsen

Try:

=COUNTIFS(Status:Status, AND(@cell = "To-Do", @cell = "In Progress"), [Days Aged]:[Days Aged], AND(@cell >14, @cell < 31)

SavvyAdam

That didn't seem to work either

SavvyAdam

I was able to get this to work going the other way, by adding exclusions instead of inclusions.

This is what I used

=COUNTIFS(Status:Status, <>"Closed", Status:Status, <>"Cancelled", [Days Aged]:[Days Aged], > 14, [Days Aged]:[Days Aged], < 31)

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.