SUM + IF function

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

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
 
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")
 
Back
Top