# COUNTIFS Issue

Options

Hi,

I am trying to count between a range of numbers. The problem is smartsheet seems to only count the first number and everything after that. It doesnt seem to count between the range.

Range to count is Probability - This has numbers ranging between 1 and 0.50

I have tried the following

=COUNTIFS({Master Programme Range 3}, >0.9, {Master Programme Range 3}, <=0.99) - This returns 1 but it should return 5

I have then tried =COUNTIF({Master Programme Range 3}, >0.9 <= 0.99) this returns 19

• ✭✭✭✭✭✭
Options

Your formula states "> 0.9". That is greater than 0.9 which means 0.9 will not be included. You need to change your criteria to ">= 0.9" so that it is greater than or equal to 0.9 so that it will be included in your count.

• ✭✭✭✭✭✭
Options

Can you show a screenshot of the data that should return 5 but is only returning 9?

• Options

Hi Paul,

Pictures attached.

• ✭✭✭✭✭✭
Options

I only see one entry at 0.95.

The other entries are either 1 or less than 0.91.

It is going to be the COUNTIFS formula that you want, but you may want to adjust your first argument to have greater than or equal to instead of just greater than 0.9.

• Options

Hi Paul,

Sorry but i am not sure I understand. As you can see there are 4 entries between 90 and 99. I want the countifs to be able to count between 90,91,92,93,94,95,96,97,98,99 and return how many there are. so in the above example it will show 4.

Thanks for your help so far.

• ✭✭✭✭✭✭
Options

Your formula states "> 0.9". That is greater than 0.9 which means 0.9 will not be included. You need to change your criteria to ">= 0.9" so that it is greater than or equal to 0.9 so that it will be included in your count.

• Options

Worked a treat. Thank you for your help.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!