Jul 08 2020 07:14 AM
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 |
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
Jul 08 2020 09:33 AM
SolutionThat 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))
Jul 08 2020 11:08 AM
@Sergei Baklan ur a genius. Thanks
Jul 08 2020 09:33 AM
SolutionThat 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))