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

bencowin · 03/14/23

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 · 03/14/23

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 · 03/14/23

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

bencowin · 03/14/23

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å · 03/14/23

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 · 03/14/23

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

Hi Andrée,

I usually get error messages like #INCORRECTARGUMENT etc..

Thanks

Nick Korna · 03/14/23

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 · 03/14/23

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

Thank you so much Nick!

Nick Korna · 03/14/23

No problem, happy to have helped! 😊

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

Best Answer

Answers

Help Article Resources

Categories