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