This should do for 11-20. Adapt as necessary for other ranges.

=(SUMIF(A1:A10,"=11",A1:A10)-SUMIF(A1:A10,"=21",A1:A10))/(COUNTIF(A1:A10,"=11")-COUNTIF(A1:A10,"=21"))

There may be more elegant ways of doing it.
--
Ian
--
"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