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

[Skykat]

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)

 

[63falcondude]

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]

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]

How's this?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1	Invoice Date	Invoice Number	Charges	Credits	Balance		Current	Over 30 Days	Over 60 Days	Over 90 Days	Balance Due
2	10/5/2016	2142	4,310.22	1,643.89	2,666.33		192.46	9115.52	4779.97	0	$14,087.95
3	10/12/2016	2147	2,071.17		4,737.50
4	10/18/2016	Finance Charge	42.47		4,779.97
5	11/2/2016	2151	8,716.83		13,496.80
6	11/9/2016	2154	398.69		13,895.49
7	12/19/2016	Finance Charge	192.46		14,087.95
Sheet1

Cell Formulas
Range	Formula
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)