Thread: averaging lines of data at every ten lines
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
  
Posts: 57
Default averaging lines of data at every ten lines
On Dec 28, 4:52*pm, MJ wrote:
I have spreadsheet with 1000 lines of data, time intervals every minute. *I
want to average every ten minutes. *Is there a realtively simple way to do
this?

Assuming your data to average is in A1:A1000 then you can average
every 10 cells with this formula in C1 copied down

=AVERAGE(OFFSET(A$1,ROWS(C$1:C1)*10-10,0,10))
Reply With QuoteReply With Quote