SUM + IF function

[That's Confidential]

I have a list of school pupils and their attainment. In column A I have
their names, column B there sex (male, female in a drop down list) and a
test result in column C.

What I want to do now is work out the average score for males in column C.
How do I type out "If Male is selected in column B, then work out the
average for the marks in Column C?"

Thanks

 

[JE McGimpsey]

One way:

=SUMIF(B:B,"male",C:C)/COUNTIF(B:B,"male")

 

[Frank Kabel]

Hi
one way:
=AVERAGE(IF(B1:B100="male",C1:C100))
This is an array formula. Has to be entered with CTRL+SHIFT+ENTER

Another way (non array):
=SUMIF(B1:B100,"male",C1:C100)/COUNTIF(B1:B100,"male")