Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
average with 2 conditions
Hi,
is there anyone who can help me with an average problem.. I want the average of say column F, when 2 conditions are fullfilled, in column A and C. I tried =AVERAGE(IF((A2:A22="X")+(C2:C22="Y"),F2:F22)) with ctrl shift enter, but i cant make it work... thanks, S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average with Conditions | Excel Worksheet Functions | |||
Average with Conditions | Excel Worksheet Functions | |||
Average with Conditions | Excel Worksheet Functions | |||
AVERAGE with conditions | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |