I’m trying to populate column C with a running total of “Payments” and “Adjustments”. This code that I’m using craps out on the “B2+C2“ part. It doesn’t grab the value from B2to add to the 0 value in C2. It gives me a circular reference. Any ideas?

My code in C2: =IF(A2<>"Charges",B2,0),IF(A2<>"Charges",B2+C2,C2))

This is how I need the result to appear:

Column A (Type of Transaction) Column B (Total Paid/Charged) Column C Running Total
Charge $105.00 $-
Payment ($87.00) ($87.00)
Adjustment ($13.00) ($100)
Charge $50 ($100)
Adjustment ($25) ($125)
…