Hi,
Ia have a sequence of numbers in Col A which reflect expenses (in -) and revenues (in +). I want a formula that will produce the outcome shown in Col B.
Basically I am looking for a formula that will calculate the rolling sum and "report" it only when it becomes positive, thereafter starting over from the the next row.
The attached file depicts the input in Col A and the manually entered output in Col B.
I thank you for any help offered.
Best
Alexander
Ia have a sequence of numbers in Col A which reflect expenses (in -) and revenues (in +). I want a formula that will produce the outcome shown in Col B.
Basically I am looking for a formula that will calculate the rolling sum and "report" it only when it becomes positive, thereafter starting over from the the next row.
The attached file depicts the input in Col A and the manually entered output in Col B.
I thank you for any help offered.
Best
Alexander