Need help with COUNTIFS formula

SavvyAdam

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

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)

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)