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

=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

Hi John..........

A Pivot Table could be used here also to give you a nice display of each
Class and the count of Males and Females in each and the total students in
each as well.........

Vaya con Dios,
Chuck, CABGx3



"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

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

Thanks to all for the help, I managed using the sumproduct function. I
will have a look at pivot tabled as well.