Hi there,
I was wondering if anyone had a solution to this.
I have attached a working example of the problem and the desired solution in column C.
I am producing a spreadsheet of accounts and have a number of rows which need to be the sum of previous rows (in that column).
Instead of manually summing the number of rows I was wondering if it could be done automatically someway to add all the numbers above it until it reaches the last sum?
Does that make any sense?! The real version is much bigger, and rows can be added and taken away which I didn't want to be missed out...
Thanks for any help, would be really appreciated.
Sam
Bookmarks