B
broer konijn
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+