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

=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

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

No no i am sorry, I got it now. My mistake!!
Thank you so much!!

Regards Sara

"s" wrote:

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

The condition is not met in any pair of cells.

--
Kind regards,

Niek Otten

"s" wrote in message ...
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

It works fine for me if I have any rows that meet the condition and have
numbers stored as numbers in column F.

--
Regards,
Tom Ogilvy


"s" wrote:

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

hi Tom, My mistake I am sorry.
it works just fine now.
Thank you very much!!

Sara


"Tom Ogilvy" wrote:

It works fine for me if I have any rows that meet the condition and have
numbers stored as numbers in column F.

--
Regards,
Tom Ogilvy


"s" wrote:

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