# Formula Help

#### smpaz7467

##### Board Regular
In cell C3:C23 there are dollar amount to be paid and in E3:E23 there is the date when it is paid. What I want to do is put in a formula that would total up all dollar amounts in Column C and when I pay them it would subtract the amounts that have been paid based up a date being in coulmn E. Any help would be appreciated.

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### lenze

##### Legend
Code:
``=SUM(C3:C23)-SUMPRODUCT(--(LEN(E3:E23)>0)*(C3:C23))``

lenze

#### smpaz7467

##### Board Regular
Works great thanks for the help

Replies
1
Views
373
Replies
0
Views
319
Replies
14
Views
682
Replies
5
Views
173
Replies
2
Views
451

1,191,092
Messages
5,984,612
Members
439,896
Latest member
SquareCare

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back