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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Can you show a screenshot of the data that should return 5 but is only returning 9?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Worked a treat. Thank you for your help.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!