adding to Bob's response - check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for details on how the SUMPRODUCT function works

Cheers
JulieD

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A1:A100="class"),--(B1:B100="male"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John_Lamb" wrote in message
om...
I have 2 columns of data the first contains students classes, the
second their gender. I would like to enter a function that counts the
male or female students in a group. I have tried "COUNTIF(AND.... with
no success