Forum Discussion

Copper Contributor

Nov 28, 2019

Excel mean every X cells

Hi, I need to make the mean of groups of cells, taking the values every 10 cells. Could someone suggest a formula to do this?

excel

Formulas and Functions

mroyo

Copper Contributor

Nov 29, 2019

Hi Jan,

Thanks a lot for your reply.

I need it the way mention first, average A1:A11 A12:A21 A22:A31.....

JKPieterse

Silver Contributor

Nov 29, 2019

Assuming your data starts in cell A2, enter this formula in B2:
=AVERAGE(OFFSET($A$2,10*(ROW(B2)-ROW($B$2)),,10,1))
Copy down as far as your data in col A goed divided by 10.