View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dysonsphere dysonsphere is offline
external usenet poster
 
Posts: 2
Default How to get average of successive x-number cells to output in colum

I would like to get the average of 30 cells in a column output to a cell in
another column. Then have the next 30 cells averaged in the next cell down.
If I tell excel to get the average 30 cells then copy that to the next cell
down it takes the average of the 30 cells starting from row 2 instead of from
row 31.