Forum Discussion

arvexcel's avatar
arvexcel
Copper Contributor
Jul 08, 2020
Solved

Adding Consecutive cells and listing them out

List Sum of 3 consecutive Nos This is how I want it 2 12 12 3   15 7   15 5 15 9 8     2     2 15   7     6     1 9   3     5     ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 08, 2020

    arvexcel 

    That could be

    or

    =SUM(INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+1):INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+3))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 08, 2020

arvexcel 

That could be

or

=SUM(INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+1):INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+3))

Resources