Multiple IF formulas totalling in one cell

[Sorna2020]

I have a past due spreadsheet. I would like a running total of past due amount. As customers pay, they should not be included in total- see table below, Total Past Due amount does not include invoices DEF or MNO because they have been paid.
Something along the lines of (CELL D1)If (D3=0, C3, 0) + (D4=0, C4, 0) + (D5=0, C5, 0).
I realized that formula does not work- looking for something that does. Also look for how to duplicate as there are 1,000 lines.

THANK YOU!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]Total Past Due:
[/TD]
[TD="align: center"]$1,602
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]Customer
[/TD]
[TD="align: center"]Invoice#
[/TD]
[TD="align: center"]Amount Due
[/TD]
[TD="align: center"]Date Paid
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]ABC
[/TD]
[TD="align: center"]1234
[/TD]
[TD="align: center"]$12300
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]DEF
[/TD]
[TD="align: center"]5678
[/TD]
[TD="align: center"]$234.00
[/TD]
[TD="align: center"]02/06/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"]GHI
[/TD]
[TD="align: center"]9101
[/TD]
[TD="align: center"]$345.00
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: center"]JKL
[/TD]
[TD="align: center"]1121
[/TD]
[TD="align: center"]$456.00
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: center"]MNO
[/TD]
[TD="align: center"]3141
[/TD]
[TD="align: center"]$567.00
[/TD]
[TD="align: center"]02/01/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD="align: center"]PQR
[/TD]
[TD="align: center"]5161
[/TD]
[TD="align: center"]$678.00
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[63falcondude]

Maybe something along the lines of

=SUMIF(D3:D8,"",C3:C8)

 

[Sorna2020]

Worked great! Thanks!!

 

[63falcondude]

Worked great! Thanks!!

You're welcome. Glad to help.