T T. Valko Nov 14, 2007 #2 Assume the numbers are in the range A1:A10000 I also assume you want the average of A1:A50, A51:A100, A101:A150, etc. Enter this formula in C1 and copy down as needed: =AVERAGE(OFFSET(A$1,ROWS(C$1:C1)*50-1,,-50))
Assume the numbers are in the range A1:A10000 I also assume you want the average of A1:A50, A51:A100, A101:A150, etc. Enter this formula in C1 and copy down as needed: =AVERAGE(OFFSET(A$1,ROWS(C$1:C1)*50-1,,-50))
