AMVERAGIF Condition

[rwtrader]

I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?

 

[steve]

"And" will return true/false, try using IF(AND(-------)) which will return a
value as the criteria.

Regards
Steve

 

[Max]

Don't know the new function AVERAGEIF,
but indicatively something like this array-entered should do it:
=average(if((Cond1)*(Cond2),Range))

 

[Teethless mama]

=AVERAGEIF(AvgRange,Range1,Criteria1,Range2,Criteria2)

 

[Jackpot]

Try
AverageIfs()

 

[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

 

[rwtrader]

What is the syntax for AverageIfs? I don't see that function in 2007.