Thank you,

but then I get #DIV/0!
Hmmm, what am i doing wrong?

Regards sara

"Tom Ogilvy" wrote:

=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