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!
Best Answer

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

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,

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


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
Categories
Check out the Formula Handbook template!