Formulas COUNTIF between to numbers

Laura Cox

Hello,

I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues.

=COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59")

It returns a number but the wrong number. it is not considering the <=59 part of the formula. So I get a count from 30 and all the way up to the highest number in that column. Hopefully, someone can help me.

Thank You 

Laura

Andrée Starå

Hi Laura,

Try this. (Change the ranges first)

=COUNTIFS([Audit Cap]:[Audit Cap]; >=30; [Audit Cap]:[Audit Cap]; <=59)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting