performing conditional averages.

  • Thread starter Thread starter vinnie123
  • Start date Start date
V

vinnie123

Hi,

I've got a sheet with about 1500 rows and 30 columns. The data in one
column I've named Gender and in another EthnicGroup. with text
strings in the cell. In a third column with data named Age is a whole
number. (via the define name function)

{=AVERAGE(IF(Gender="Male",Age))} will give me the average age for
males and {=AVERAGE(IF(EthnicGroup="Russian",Age))} will give me the
average age for Russians.

I want to calculate the average age of Russians who are male. I can't
get IF(and(etc to do it. any suggestions.?

Thanks.
 
Try this (array entered):

=AVERAGE(IF((Gender="Male")*(EthnicGroup="Russian"),Age))

Biff
 
Back
Top