lzweifel
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 213
Hello All,
I am looking for a formula to calculate the totals of one column IF the cell of another is empty.
I have a table set up to calculate days from Invoice Date to the date those invoices are paid... Column C has the amount of the invoice, Column E has the date in which it was paid. What I am looking for is a total running of the amount in Column C but only those invoices which have not yet been paid, in which case Column E would still be blank.
COLUMN B COLUMN C COLUMN E COLUMN F
Invoice 1 $ 50.00 $250.00
Invoice 2 $150.00 09-12-16
Invoice 3 $200.00
In this example my formula would be in Column F and calculating the invoice which have not been paid (Invoice 1 and 3) If I was to add Invoice 4 for $100 Column F would than re-calculate to $350.00
Thank you so much in advance, always, always appreciate your help!!
L
I am looking for a formula to calculate the totals of one column IF the cell of another is empty.
I have a table set up to calculate days from Invoice Date to the date those invoices are paid... Column C has the amount of the invoice, Column E has the date in which it was paid. What I am looking for is a total running of the amount in Column C but only those invoices which have not yet been paid, in which case Column E would still be blank.
COLUMN B COLUMN C COLUMN E COLUMN F
Invoice 1 $ 50.00 $250.00
Invoice 2 $150.00 09-12-16
Invoice 3 $200.00
In this example my formula would be in Column F and calculating the invoice which have not been paid (Invoice 1 and 3) If I was to add Invoice 4 for $100 Column F would than re-calculate to $350.00
Thank you so much in advance, always, always appreciate your help!!
L