Hi!

To average values that are 25 but <50:

Array entered using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF(A1:A1025,IF(A1:A10<50,A1:A10)))

Biff

"stew1901" wrote in
message ...

Hi all

First post! I hope this is the right section!

I need to calculate a simple average (arithmetic and median) of a set
of numbers, but excluding certain outlying points. I'm not by any
means a newbie to coding so I do know how I'd do this generally in a
programming language or "pseudo code" (so no need to waste your time on
long explanations!) but I am completely new to Excel so have no idea of
the syntax and don't really have the time to mess around with the
"guess the useful phrase" help function.

Thanks in advance...I hope...


--
stew1901
------------------------------------------------------------------------
stew1901's Profile:
http://www.excelforum.com/member.php...o&userid=29164
View this thread: http://www.excelforum.com/showthread...hreadid=488880