Formulas COUNTIF between to numbers

Laura Cox
Laura Cox ✭✭
edited 12/09/19 in Formulas and Functions


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 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!