Thread: Average
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Average

Danny wrote...
I have a column of numbers for which i need to average every 12 rows(i.e
average rows 1-12, 13-24, 25-36, etc). It is two years worth of data (730
days) with 12 entries per day. I need the average daily readings for each
day.

Is there a simple and efficient method to copy and paste the same formula
for all 730 days. I know I can use the average function for each range, but
that is a lot of typing!


Check the responses to your previous, nearly identical posting before
you respond or (Gawd Ferbid!) start another thread.