=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