Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
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! Thanks in advance! Danny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
Hi!
One way: Assume data is in column A, A1:An. Enter this formula in B1: =AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*12,,12)) Copy down as needed. The results will be like this: B1 = AVERAGE(A1:A12) B2 = AVERAGE(A13:A24) B3 = AVERAGE(A25:A36) B4 = AVERAGE(A37:A48) etc Biff "Danny" wrote in message ... 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! Thanks in advance! Danny |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
Yes, sorry about the multiple positng. I was travelling and in the middle of
a major thunder storm. Right when I hit the send button we lost power. After checking & recehcing, I could nto find my original post, so i had to recreate. "Harlan Grove" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
Biff,
Thanks! It solved my problem and I am on my way! "Biff" wrote: Hi! One way: Assume data is in column A, A1:An. Enter this formula in B1: =AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*12,,12)) Copy down as needed. The results will be like this: B1 = AVERAGE(A1:A12) B2 = AVERAGE(A13:A24) B3 = AVERAGE(A25:A36) B4 = AVERAGE(A37:A48) etc Biff "Danny" wrote in message ... 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! Thanks in advance! Danny |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
You're welcome. Thanks for the feedback!
Biff "Danny" wrote in message ... Biff, Thanks! It solved my problem and I am on my way! "Biff" wrote: Hi! One way: Assume data is in column A, A1:An. Enter this formula in B1: =AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*12,,12)) Copy down as needed. The results will be like this: B1 = AVERAGE(A1:A12) B2 = AVERAGE(A13:A24) B3 = AVERAGE(A25:A36) B4 = AVERAGE(A37:A48) etc Biff "Danny" wrote in message ... 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! Thanks in advance! Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |