try this formula
=SUMPRODUCT((A2:A20<=13)*(B2:B20="f"))-SUMPRODUCT((A2:A20<9)*(B2:B20="f"))
modify to suiy you
"Clash" wrote in
message ...
Can anybody please help?
I'm trying to find out the following, How many 09-13 year olds enjoy
Football.
The spreadsheet is set up as column A, DOB. Column B formula to work
out Age in years, what sport you enjoy? in which there are varying
answers.
I can do a short array eg Gender & Sport, but because of the age
catergories it has completely foxed me.
Thanks
Clash:)
--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=572969