count age ranges
 

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") which
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 thanks


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=551400

count age ranges
 

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.

"Clash" wrote:


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") which
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 thanks


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=551400

count age ranges
 

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Clash" wrote in
message ...

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") which
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 thanks


--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=551400

count age ranges
 

=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)

"Clash" wrote in
message ...

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") which
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 thanks


--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=551400