COUNTIFS when value falls between X and Y

Chris Hallo

Hello! So, my summary field for 00-30 days (using Days Open) works fine. I'm running into issues though on 31-60, 61-90 and 91-180...not sure the syntax for the range. Help, please :)!!

Nic Larsen

Something like this should work. Just update the formula for each range:

=COUNTIFS([Days Open]:[Days Open], >30, [Days Open]:[Days Open], <=60)

Chris Hallo

Thanks, Nic. I just added an equal sign between and 30 and all good. I appreciate the prompt reply :).

Nic Larsen

Something like this should work. Just update the formula for each range:

=COUNTIFS([Days Open]:[Days Open], >30, [Days Open]:[Days Open], <=60)

Chris Hallo

Thanks, Nic. I just added an equal sign between and 30 and all good. I appreciate the prompt reply :).