R
rwtrader
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?
AVERAGEIF statement. Is there a trick to doing this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
steve
"And" will return true/false, try using IF(AND(-------)) which will return a
value as the criteria.
Regards
Steve
value as the criteria.
Regards
Steve
M
Max
Don't know the new function AVERAGEIF,
but indicatively something like this array-entered should do it:
=average(if((Cond1)*(Cond2),Range))
but indicatively something like this array-entered should do it:
=average(if((Cond1)*(Cond2),Range))
T
Teethless mama
=AVERAGEIF(AvgRange,Range1,Criteria1,Range2,Criteria2)
J
Jackpot
Try
AverageIfs()
AverageIfs()
B
Bernard Liengme
There is no need to use AND
This formula
=AVERAGEIFS(A2:A10,B2:B10,">=20",B2:B10,"=<50")
will average the values in the A range when the corresponding B values lie
in the interval 20 to 50
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
This formula
=AVERAGEIFS(A2:A10,B2:B10,">=20",B2:B10,"=<50")
will average the values in the A range when the corresponding B values lie
in the interval 20 to 50
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
R
rwtrader
What is the syntax for AverageIfs? I don't see that function in 2007.