countif I think

[chris]

thanks for reading this.
how can I count two different criteria at once. I want to be able to
count how many males are in group a and how many are in group b
without sorting the spreadsheet

group gender
a m
b f
a m
b f
b f
b m




cheers

 

[JulieD]

Hi Chris

=SUMPRODUCT(--(A1:A100="b"),--(B1:B100="m"))
where A1:A100 is the group range and B1:B100 is the gender range

check out the following web page for details on sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Cheers
JulieD

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100="a"),--(B1:B100="m"))

 

[mar10a]

Would this work - create a third column which is a combination of the first 2,
then do a COUNTIF statement based on the new column

if column A is group, column B is gender make column C =+A2&B2 etc....

then use a COUNTIF statement off this new column =COUNTIF(c2:c100,"AM")