Subtract cells based on previous and current values of other cells

[tHE fLY]

Hey everyone,

i have the following problem... It seems complex and I'm not sure how to get my formula to work

I want the following to happen

If column a has an amount then column c will have an amount
And that amount will subtract column b.. For each blank in cell a... I want column c cells to subtract the previous blank cells that have values in column B to be subtracted from column c cell...

example below.

Column a | column b | column c
100,000. |. 1000. | 17,000 (cell C1- B1)
Blank. |. 1000. |. Blank
Blank. |. 1000. |. Blank
100,000. |. 1000. | 31,000. (Cell C4 - sum(Cell B2:B4)
Blank. |. 1000. | blank.
100,000. |. 1000. |35,000. (Cell C6 -sum(B5:B6)

Thanks for your help!

 

[MarcelBeug]

Make sure to have column headers in row 1 and data starting in row 2.
Enter in D2: =IF(C2="","",SUM($C$2:C2)-SUM($B$2:B2)-SUM($D$1:D1))
Copy downwards.

 

[tHE fLY]

Marcel,

Thank you so much. I'll try that and let you know!!

 

[tHE fLY]

That worked!

Thanks!