Help with COUNTIF formula for between statement.
I am trying to show a count for how many values fall between >=100 and <150. But it is counting those in the column that fall into both categories duplicating the number. Here is my current formula: =COUNTIFS({SMARTRECRUITER, DEG Range 1}, <150, {SMARTRECRUITER, DEG Range 1}, <=100)
Then the next row would be:
=COUNTIFS({SMARTRECRUITER, DEG Range 1}, <99, {SMARTRECRUITER, DEG Range 1}, <=75)
I tried adding AND but it says #UNPARSEABLE
=COUNTIFS({SMARTRECRUITER, DEG Range 1}, <99 AND( {SMARTRECRUITER, DEG Range 1}, <=75)
Answers
-
A COUNTIFS essentially has a silent "and" as the comma, so you don't need to include this in.
It looks like you just have the > symbol the wrong way around in your first formula.
Try this:
=COUNTIFS({SMARTRECRUITER, DEG Range 1}, <150, {SMARTRECRUITER, DEG Range 1}, >=100)
And again for your second one, make sure your "greater than" symbol is the right way around:
=COUNTIFS({SMARTRECRUITER, DEG Range 1}, <99, {SMARTRECRUITER, DEG Range 1}, >=75)
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you so much! Some days you just need someone else to look at it. I kept staring at trying to figure out what I did wrong lol.
-
No problem at all! 🙂
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!