I thought there'd be a better way to do it :-)

--
Ian
--
"Bob Phillips" wrote in message
...
=AVERAGE(IF((D1:D10010)*(D1:D100<=20),D1:D100))

will give the average for 11-20. This is an array formula, so commit with
Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"smallcap" wrote
in
message ...

I have a set of data(numbers)like 1,60,50,50,44,24,10,15,13,5,15 in a
column.

Now, I have to calculate the average of ranges 0-10, 11-20, 21-30....

Please help me to write a formula.


--
smallcap
------------------------------------------------------------------------
smallcap's Profile:
http://www.excelforum.com/member.php...o&userid=28383
View this thread:
http://www.excelforum.com/showthread...hreadid=479718