Forum Discussion

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 ...

Jul 08, 2020

That could be

=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))

Diamond Contributor

Jul 08, 2020

That could be

=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))