COUNTIFS Issue

Phil2020

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

Please help it's driving me nuts

Paul Newcome

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.

Paul Newcome

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

Phil2020

Hi Paul,

Pictures attached.

Paul Newcome

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.

Phil2020

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.

Paul Newcome

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.

Phil2020

Worked a treat. Thank you for your help.

Paul Newcome

Happy to help. 👍️