Forum Discussion

mroyo's avatar
mroyo
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
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 29, 2019
Do you need to average cells
A1:A10, A11:A20, A21:A30, ...
or do you need to average
A1, A11, A21, A31, ... A101
A2, A12, A22, A32, ... A102
mroyo's avatar
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's avatar
    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.

Resources