From: Bernard Liengme on
There is no need to use AND
This formula
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
REMINDER: These newsgroups are about to die. We will all meet again at

"rwtrader" <rwtrader(a)> 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?