R Ragdyer Sep 11, 2005 #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)))
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)))
G Guest Sep 11, 2005 #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
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
