count age ranges

[Clash]

Hi all,

can someone please help, I'm trying to count the number of 18-21
22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") whic
counts the 18 y.o's and above, but not each oh the age ranges.
I don't know how to get the other ages to calculate.

many thank

 

[Guest]

You may use try:
=SUMPRODUCT(--($I$3:$I$10>=18),--($I$3:$I$10<22))
Change the ranges and values as appropiate

Hope this helps,
Miguel.

 

[Arvi Laanemets]

Hi

=COUNTIF($I$3:$I$10,">=18")-COUNTIF($I$3:$I$10,"<=21")

 

[Bob Phillips]

=COUNTIF($I$3:$I$10,">=18") -COUNTIF($I$3:$I$10,">21")

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)