# Formulas COUNTIF between to numbers

Options
edited 12/09/19

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

Tags:

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Yes, Thank You. It did help me and now I have the correct result. So Happy.

• ✭✭✭✭✭✭
Options

Great!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!