"COUNTIF(AND"

[John_Lamb]

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

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="class"),--(B1:B100="male"))

--

HTH

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

 

[CLR]

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

 

[JulieD]

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

 

[John_Lamb]

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