Can You do a Double CountIF?

[Jeff]

IF I have two columns of data, can i do a double CountIF?

For example, I have one column of colors and another
column of Gender. How can I count all of the Blue, Males
or Red Females?

 

[Don Guillett]

try
=sumproduct((rngA="m")*(rngB="red"))

 

[Anders S]

Hi Jeff,

It is good if you post in one group only, the regulars read them all. Otherwise you may waste peoples time. See a similar answer in ..worksheet.functions

Regards
Anders Silven