Formula to count a value within a given range
I am trying to write a formula that must meet (2) criteria and then count the number of values that are:
<500
=500 and <=999 ( this is the formula I cannot write for some reason)
>999
I have been successful at pulling the two criteria but cannot figure out how to add the count in the formula. I set them up and can pull the 500 value and the less then 500 value but not the in between value.
here is what I have to identify anything under <500:
COUNTIFS({Tank Inventory Range 2}, [Column2]19, {Tank Inventory Range 1}, [Column3]19, {Tank Inventory -Planning Range 2}, <500)
[Column2]19- Pulling Active Tanks (Active / Closed)
[Column3]19- Is pulling Air Tanks (Air / Ground)
Thanks in advance for any assistance, its greatly appreciated!!
Answers
-
If you have a range within the same column in a COUNTIFS, try listing the column twice, once for each criteria, like so:
COUNTIFS({Tank Inventory Range 2}, [Column2]19, {Tank Inventory Range 1}, [Column3]19, {Tank Inventory -Planning Range 2}, >=500, {Tank Inventory -Planning Range 2}, <=999)
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!