Did you mean =AVERAGE($B$2:B8) i.e. average all entries in column B?

If so, you could use =AVERAGE(B:B)

Blanks are ignored but 0s are included in calculation

HTH

"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