Prev: Import old dos sequencial data
Next: Can't Edit Worksheet Comments
From: Bernard Liengme on 4 Jun 2010 09:40
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" <rwtrader(a)discussions.microsoft.com> wrote in message
news:FD0D4875-8F7C-48C4-9AA5-1E3964E0A171(a)microsoft.com...
> I am having trouble adding an AND statement to the condition portion of
> the
> AVERAGEIF statement. Is there a trick to doing this?

First  |  Prev  | 
Pages: 1 2
Prev: Import old dos sequencial data
Next: Can't Edit Worksheet Comments