Count cells provided another cell has a particular entry

[Wicks]

I have a list of names with a column next to it
indicating Gender. Next to that are several other
columns with coded answers to a questionaire.
I am trying to find out by Gender how many people
answered with code 1, code 2 etc.

I have been trying to use Countif
eg =countif(B2:B125,"m") gives me all the males in
column B, but I want the number of males in column B who
have answered 1 in column C, and then the # of males who
have answered 2 etc etc.

 

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(B2:B125="M"),--(C2:C125=1))

Biff