Ardus,
Briljant! This does the trick! :)



Ardus Petus Wrote:
=AVERAGE(INDIRECT("B$"&MATCH(A2,A$2:A$16,0)+ROW(A$ 1)&":B"&ROW()))

HTH
--
AP

"Toppers" a écrit dans le message
de
news: ...
Soryy ... re-read your mail and my answer is wrong! What decides the
new
starting point i.e your example, is it always 6 cells?

"broer konijn" wrote:


Consider the attached issue.

I calculate average values for a list of units. How would you advise
to
calculate the averages, without having to manually move the
starting
point, every time when a new unit is listed?

Thus how does =AVERAGE($B$2:B7) move to =AVERAGE($B$8:B8)?





+-------------------------------------------------------------------+
|Filename: Book1.zip
|
|Download: http://www.excelforum.com/attachment.php?postid=4925
|

+-------------------------------------------------------------------+

--
broer konijn

------------------------------------------------------------------------
broer konijn's Profile:
http://www.excelforum.com/member.php...o&userid=34402
View this thread:
http://www.excelforum.com/showthread...hreadid=554626




--
broer konijn
------------------------------------------------------------------------
broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402
View this thread: http://www.excelforum.com/showthread...hreadid=554626