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

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

Regards
Steve

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

Don't know the new function AVERAGEIF,
but indicatively something like this array-entered should do it:
=average(if((Cond1)*(Cond2),Range))
--
Max
Singapore
---
"rwtrader" wrote:
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?

=AVERAGEIF(AvgRange,Range1,Criteria1,Range2,Criter ia2)


"rwtrader" wrote:

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

Try
AverageIfs()

"rwtrader" wrote:

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

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/...ry/officeexcel

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

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

"Jackpot" wrote:

Try
AverageIfs()

"rwtrader" wrote:

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