COUNTIFS Issue
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
Best Answer

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

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

Hi Paul,
Pictures attached.

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.

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.

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.

Worked a treat. Thank you for your help.

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!