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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    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).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!