Countif / Countifs values are between "0" and "10"

✭✭

Hi all,

Struggling with a formula and could use a hand.

I'm trying to display data which shows me how many values are outstanding between 0 and 10 days.

I've tried a few formulas but none of them seem to be working, which is driving me insane!

=COUNTIF({MS - Range 5} < 10)

As shown in the above, i've even tried to simplify it so that it just shows me values that are outstanding for less than 10 days - still no luck.

Any suggestions are greatly appreciated, thanks!

• ✭✭✭✭✭✭

Your formula would be:

=COUNTIFS({Status}, "Outstanding", {Amount of Days overdue}, <=10)

Where the cross sheet ranges are the respective columns from your screenshot (you can have them as different names obviously). This should give you the desired result (1, from the example data).

• ✭✭✭✭✭✭

Can you post a screenshot of some example data of the range being checked?

• ✭✭

Hi Nick, Please see above.

Most of it is sensitive data so i'm unable to show the rest of the sheet.

Thanks,

• ✭✭✭✭✭✭

I hope you're well and safe!

Do you get an error message or the wrong amount?

Be safe, and have a fantastic week!

Best,

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

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

• ✭✭

Hi Andrée,

I usually get error messages like #INCORRECTARGUMENT etc..

Thanks

• ✭✭✭✭✭✭

Your formula would be:

=COUNTIFS({Status}, "Outstanding", {Amount of Days overdue}, <=10)

Where the cross sheet ranges are the respective columns from your screenshot (you can have them as different names obviously). This should give you the desired result (1, from the example data).

• ✭✭

Thank you so much Nick!

• ✭✭✭✭✭✭

No problem, happy to have helped! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!