Forum Discussion
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 ...
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 ur a genius. Thanks
arvexcel , you are welcome