Hi
I have a set of data roughly couple thousand going down on an excel sheet. (e.g. say Colum A contains numerical data going down)
I need to find a way to compute a sum of consecutive data for sum of 2 consecutive numbers, 3 consecutive numbers, 4... etc up to the total number of data in colum A. (e.g. if colum A contains 1000 data, then i would need 1000 different sums)
For example: (left most column is data)
1 1 3 6 .......
2 2 5 9 .......
3 3 7 12 .......
4 4 9 15 .......
5 5 11 18 ......
6 6 13 .......
7 7
I would like to get it on excel since that's where the data is.. but i wouldn't mind doing it on some other platform either. Thanks!
Start Free Trial
