Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel question
How can I get the average of every six values (rows) in a column?
|
#2
|
|||
|
|||
Do you mean:
1 to 6 2 to 7 3 to 8 Then just enter this formula and copy down as needed: =AVERAGE(A1:A6) OR, do you mean: 1 to 6 7 to 12 13 to 18 Then just enter this formula and copy down as needed: =AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1))) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jt42" wrote in message ... How can I get the average of every six values (rows) in a column? |
#3
|
|||
|
|||
Yes, I meant the latter:
1 to 6, 7 to 12, 13 to 18, etc. I thought that perhaps there is a formula using bin of 6, but what you suggested works very well. Many thanks, Joanna "Ragdyer" wrote: Do you mean: 1 to 6 2 to 7 3 to 8 Then just enter this formula and copy down as needed: =AVERAGE(A1:A6) OR, do you mean: 1 to 6 7 to 12 13 to 18 Then just enter this formula and copy down as needed: =AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1))) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jt42" wrote in message ... How can I get the average of every six values (rows) in a column? |
#4
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jt42" wrote in message ... Yes, I meant the latter: 1 to 6, 7 to 12, 13 to 18, etc. I thought that perhaps there is a formula using bin of 6, but what you suggested works very well. Many thanks, Joanna "Ragdyer" wrote: Do you mean: 1 to 6 2 to 7 3 to 8 Then just enter this formula and copy down as needed: =AVERAGE(A1:A6) OR, do you mean: 1 to 6 7 to 12 13 to 18 Then just enter this formula and copy down as needed: =AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1))) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "jt42" wrote in message ... How can I get the average of every six values (rows) in a column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
Excel Question....Help !!!! | Excel Discussion (Misc queries) | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |