|
calculating average with moving startpoint
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)? :confused: +-------------------------------------------------------------------+ |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 |
calculating average with moving startpoint
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)? :confused: +-------------------------------------------------------------------+ |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 |
calculating average with moving startpoint
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)? :confused: +-------------------------------------------------------------------+ |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 |
calculating average with moving startpoint
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)? :confused: +-------------------------------------------------------------------+ |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 |
| All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com