Need help to Loop Backwards and count totals in two different columns...

[swade730]

Hi guys,

I was wondering if someone can show me how to achieve the following...

Attached is the spread sheet.

my goal is to use the starting total in cell D13

I want to add the values from column A BUT if I am adding a POSITIVE number to the starting total I want the result to be shown in column B.

If I am adding a NEGATIVE number from the starting total, the result should show in column D.

So essentially there are two independent calculations going on simultaneously based off the starting total.

Any Help would be greatly Appreciated.

[FDibbins]

For the plus's, in B12, copied upwards...
=$D$13+SUMIF(A12:$A$12,">0")
Repeat for the minuses...
=$D$13+SUMIF(A12:$A$12,"<0")