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

bencowin

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!

Nick Korna

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).

Nick Korna

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

bencowin

https://community.smartsheet.com/discussion/comment/367066#Comment_367066

Hi Nick, Please see above.

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

Thanks,

Andrée Starå

Hi @bencowin

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!

bencowin

https://community.smartsheet.com/discussion/comment/367069#Comment_367069

Hi Andrée,

I usually get error messages like #INCORRECTARGUMENT etc..

Thanks

Nick Korna

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).

bencowin

https://community.smartsheet.com/discussion/comment/367081#Comment_367081

Thank you so much Nick!

Nick Korna

No problem, happy to have helped! 😊