Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
performing conditional averages.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
performing conditional averages.
Try this (array entered):
=AVERAGE(IF((Gender="Male")*(EthnicGroup="Russian" ),Age)) Biff "vinnie123" wrote in message ps.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I figured out how to do total averages in Pivot Charts! | Charts and Charting in Excel | |||
Conditional Averages | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |