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

3 Replies

  • 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