SOLVED

Adding Consecutive cells and listing them out

Copper Contributor
ListSum of 3 consecutive NosThis is how I want it
21212
3 15
7 15
5159
8  
2  
215 
7  
6  
19 
3  
5  

 

How can i create the third column for the data in Column1 and the input 3 (i.e. 3 consecutive numbers.. i want to add them up in this case).

 

Thanks

3 Replies
best response confirmed by arvexcel (Copper Contributor)
Solution

@arvexcel 

That could be

image.png

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

@Sergei Baklan ur a genius. Thanks

@arvexcel , you are welcome

1 best response

Accepted Solutions
best response confirmed by arvexcel (Copper Contributor)
Solution

@arvexcel 

That could be

image.png

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

View solution in original post