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!
<tbody>
</tbody>
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!
A | B | C | D | |
1 | Total Past Due: | $1,602 | ||
2 | Customer | Invoice# | Amount Due | Date Paid |
3 | ABC | 1234 | $12300 | |
4 | DEF | 5678 | $234.00 | 02/06/2017 |
5 | GHI | 9101 | $345.00 | |
6 | JKL | 1121 | $456.00 | |
7 | MNO | 3141 | $567.00 | 02/01/2017 |
8 | PQR | 5161 | $678.00 |
<tbody>
</tbody>