How to Count a group of numbers

Matthew Manicke

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!

Paul Newcome

Try somethign like this...

=COUNTIFS({Other Sheet Age Column}, AND(@cell >= 6, @cell <= 13))