# Sum of invoices, subtract credits, with current, over 30 days, over 60, and over 90

#### Skykat

##### New Member
I have a project at work for an invoice statement to send to customers, and it can not seem to get excel to work for me.

Column A Invoice Date Column B Invoice Column C Charges Column D Credits Column E Balance

However at the bottom she wants the current (A), Over 30 days(B), Over 60 days(C), and Over 90(D) days balance to show in each spot.

The problem I seem to have is that I can get it to work with =SUMIF, but if I try to subtract the credits column It says too many arguments or just says I have an error.

I'm using Excel 2011 on a MAC

(why this employer insists on MACs I have no idea)

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### 63falcondude

##### Well-known Member
Can you share some sample data along with the expected outcome of the formulas for that data? I am not sure what has to get added or subtracted.

#### Skykat

##### New Member
 Invoice Date Invoice Number Charges Credits Balance 10/5/16 2142 4,310.22 1,643.89 2,666.33 10/12/16 2147 2,071.17 4,737.50 10/18/16 Finance Charge 42.47 4,779.97 11/2/16 2151 8,716.83 13,496.80 11/9/16 2154 398.69 13,895.49 12/19/16 Finance Charge 192.46 14,087.95 Current Past Due Over 30 days Over 60 Days Over 90 Days Balance Due 192.46 9,115.52 4,779.97 \$14,087.95

<tbody>
</tbody>

#### 63falcondude

##### Well-known Member
How's this?

Excel 2010
ABCDEFGHIJK
1Invoice DateInvoice NumberChargesCreditsBalanceCurrentOver 30 DaysOver 60 DaysOver 90 DaysBalance Due
210/5/201621424,310.221,643.892,666.33192.469115.524779.970\$14,087.95
310/12/201621472,071.174,737.50
410/18/2016Finance Charge42.474,779.97
511/2/201621518,716.8313,496.80
611/9/20162154398.6913,895.49
712/19/2016Finance Charge192.4614,087.95
Sheet1
Cell Formulas
RangeFormula
H2=SUMIFS(C:C,A:A,"<="&TODAY()-30,A:A,">"&TODAY()-60)-SUMIFS(D:D,A:A,"<="&TODAY()-30,A:A,">"&TODAY()-60)
I2=SUMIFS(C:C,A:A,"<="&TODAY()-60,A:A,">"&TODAY()-90)-SUMIFS(D:D,A:A,"<="&TODAY()-60,A:A,">"&TODAY()-90)
J2=SUMIFS(C:C,A:A,"<="&TODAY()-90)-SUMIFS(D:D,A:A,"<="&TODAY()-90)

Replies
3
Views
1K
Replies
9
Views
837
Replies
4
Views
1K
Replies
3
Views
2K
Replies
14
Views
682

1,191,184
Messages
5,985,175
Members
439,945
Latest member
ospe

### 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