Subtract cell value from running total based on if another cell is filled

[bloomingcarrot]

Hi There-

I have a spreadsheet that has a running total in cell G5. I would like to subtract a cells value from range B4 to B21 if the corresponding cell in range D4 to D21 is filled with PAID. Meaning, if cell D8 = "PAID" then subtract cell B8 from running total in cell G5.

Can someone help with a formula that will achieve this?

Thank you!!

 

[Aladin Akyurek]

What is the formula that you have in G5?

 

[bloomingcarrot]

Sorry my delayed response. This is the formula is G5 - =SUM(G5+G8+G11)

Thank you!

 

[Aladin Akyurek]

Sorry my delayed response. This is the formula is G5 - =SUM(G5+G8+G11)

Thank you!

This should give you a circular reference error when entered in G5!...

By the way,

=SUMIFS($B$4:$B$21,$D$4:$D$21,"PAID")

would give you a total associated "paid".

 

[bloomingcarrot]

That worked! Thank you!!