Hello all,
I'm try to do the below to make some very time consuming work a case of copying and pasting a formula but I don't even know if it's possible. Any help would be very much appreciated.
Basically I've got a column of numbers ranging from 0 to 10,000 and I want the cell next to the number to = the sum of all numbers above it until it hits a 0. Obviously I can do this manually but is there any formula that can do this so I can just copy & paste (drag) the formula down column C?
So for example (please see the attached)
Cell C5 would = A2 + A3 +A4 +A5 (but no cells above A1)
Cell C7 would = A6 +A7 (but no cells above A5)
Cell C10 would = A6 + A7 + A8 + A9 + A10 (but no cells above A5)
Cell C17 would = A16 + A17 (but no cells above A15)
What do you think? Is it possible?
Any help would be very much appreciated.
Dave
Bookmarks