How to Count a group of numbers
Hi Everyone I'm Trying to figure out how many of our kids enrolled in our study are in our study like so.
Where I'm getting stuck on is how to count for the range such as 6-13. Here is the syntax that I currently have.
COUNTIF({SOC Wraparound Client Tracker Range 12}, "6" = COUNTIF({SOC Wraparound Client Tracker Range 12}, "7")) + COUNTIF({SOC Wraparound Client Tracker Range 12}, "8") + COUNTIF({SOC Wraparound Client Tracker Range 12}, "9") + COUNTIF({SOC Wraparound Client Tracker Range 12}, "10") + COUNTIF({SOC Wraparound Client Tracker Range 12}, "11") + COUNTIF({SOC Wraparound Client Tracker Range 12}, "12") + COUNTIF({SOC Wraparound Client Tracker Range 12}, "13")
I know that this is wrong because I'm pulling from this data set and we don't have nearly that many kids between the ages of 6-13. Here is a snippet of that data set.
If anyone could help me out I would really appreciate it, Thank you!
Answers
-
Try somethign like this...
=COUNTIFS({Other Sheet Age Column}, AND(@cell >= 6, @cell <= 13))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!