average with 2 conditions
=AVERAGE(IF((A2:A22="X")*(C2:C22="Y"),F2:F22))
Entered with Ctrl+Shift+Enter
--
Regards,
Tom Ogilvy
"s" wrote:
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
|