Thread: average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny
 
Posts: n/a
Default average

I have a very longer list (column) of numbers for two years, by day. Each
day contains 12 numeric entries. I need to determine the daily average of
these numbers. While an average formula can simply be used, it has to be
re-entered for every 12 rows 730 times (365x2). Is there a more efficent way
to write the average formula and then copy? Basically the first 12 numbers
are averaged, then the next 12 down the column, then the next 12, etc.

Thanks in advance,

Danny