average with 2 conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you,

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

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

Regards Sara
 
It works fine for me if I have any rows that meet the condition and have
numbers stored as numbers in column F.
 
hi Tom, My mistake I am sorry.
it works just fine now.
Thank you very much!!

Sara
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average/Sum formula with offset 5
Insert text in column A and calculate the average from column B 4
Averaging adjacent Columns 3
Average with Conditions 1
please help me w/ changing my formula 2
average using two criteria 2
Weighted Average with multiple conditions 3
How to Average with Conditions 6

Back
Top