Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
in a pivot table, can the average include blank entries? | Excel Discussion (Misc queries) | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |