software

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

Danny wrote...
gt;I have a column of numbers for which i need to average every 12 rows(i.e
gt;average rows 1-12, 13-24, 25-36, etc). It is two years worth of data (730
gt;days) with 12 entries per day. I need the average daily readings for each
gt;day.
gt;
gt;Is there a simple and efficient method to copy and paste the same formula
gt;for all 730 days. I know I can use the average function for each range, but
gt;that is a lot of typing!

Check the responses to your previous, nearly identical posting before
you respond or (Gawd Ferbid!) start another thread.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

quot;Dannyquot; gt; wrote in message
...
gt;I have a column of numbers for which i need to average every 12 rows(i.e
gt; average rows 1-12, 13-24, 25-36, etc). It is two years worth of data (730
gt; days) with 12 entries per day. I need the average daily readings for each
gt; day.
gt;
gt; Is there a simple and efficient method to copy and paste the same formula
gt; for all 730 days. I know I can use the average function for each range,
gt; but
gt; that is a lot of typing!
gt;
gt; Thanks in advance!
gt;
gt; Danny
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 amp; recehcing, I could nto find my original post, so i had to
recreate.

quot;Harlan Grovequot; wrote:

gt; Danny wrote...
gt; gt;I have a column of numbers for which i need to average every 12 rows(i.e
gt; gt;average rows 1-12, 13-24, 25-36, etc). It is two years worth of data (730
gt; gt;days) with 12 entries per day. I need the average daily readings for each
gt; gt;day.
gt; gt;
gt; gt;Is there a simple and efficient method to copy and paste the same formula
gt; gt;for all 730 days. I know I can use the average function for each range, but
gt; gt;that is a lot of typing!
gt;
gt; Check the responses to your previous, nearly identical posting before
gt; you respond or (Gawd Ferbid!) start another thread.
gt;
gt;

Biff,

Thanks! It solved my problem and I am on my way!

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; One way:
gt;
gt; Assume data is in column A, A1:An.
gt;
gt; Enter this formula in B1:
gt;
gt; =AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*12,,12))
gt;
gt; Copy down as needed.
gt;
gt; The results will be like this:
gt;
gt; B1 = AVERAGE(A1:A12)
gt; B2 = AVERAGE(A13:A24)
gt; B3 = AVERAGE(A25:A36)
gt; B4 = AVERAGE(A37:A48)
gt; etc
gt;
gt; Biff
gt;
gt; quot;Dannyquot; gt; wrote in message
gt; ...
gt; gt;I have a column of numbers for which i need to average every 12 rows(i.e
gt; gt; average rows 1-12, 13-24, 25-36, etc). It is two years worth of data (730
gt; gt; days) with 12 entries per day. I need the average daily readings for each
gt; gt; day.
gt; gt;
gt; gt; Is there a simple and efficient method to copy and paste the same formula
gt; gt; for all 730 days. I know I can use the average function for each range,
gt; gt; but
gt; gt; that is a lot of typing!
gt; gt;
gt; gt; Thanks in advance!
gt; gt;
gt; gt; Danny
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Dannyquot; gt; wrote in message
...
gt; Biff,
gt;
gt; Thanks! It solved my problem and I am on my way!
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; One way:
gt;gt;
gt;gt; Assume data is in column A, A1:An.
gt;gt;
gt;gt; Enter this formula in B1:
gt;gt;
gt;gt; =AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*12,,12))
gt;gt;
gt;gt; Copy down as needed.
gt;gt;
gt;gt; The results will be like this:
gt;gt;
gt;gt; B1 = AVERAGE(A1:A12)
gt;gt; B2 = AVERAGE(A13:A24)
gt;gt; B3 = AVERAGE(A25:A36)
gt;gt; B4 = AVERAGE(A37:A48)
gt;gt; etc
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dannyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a column of numbers for which i need to average every 12 rows(i.e
gt;gt; gt; average rows 1-12, 13-24, 25-36, etc). It is two years worth of data
gt;gt; gt; (730
gt;gt; gt; days) with 12 entries per day. I need the average daily readings for
gt;gt; gt; each
gt;gt; gt; day.
gt;gt; gt;
gt;gt; gt; Is there a simple and efficient method to copy and paste the same
gt;gt; gt; formula
gt;gt; gt; for all 730 days. I know I can use the average function for each
gt;gt; gt; range,
gt;gt; gt; but
gt;gt; gt; that is a lot of typing!
gt;gt; gt;
gt;gt; gt; Thanks in advance!
gt;gt; gt;
gt;gt; gt; Danny
gt;gt;
gt;gt;
gt;gt;