Count sum of amount with due dates

[willwall]

Hello
I am trying to create a formula that shows the overdue amount based on amount of days overdue. In this case i am looking to sum up the values that are overdue more than 8 to 14 days. The cells that are overdue are marked with a negative sign.
[TABLE="width: 791"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>[/TABLE]

[TABLE="width: 793"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Due date[/TD]
[TD]Amount[/TD]
[TD]Today[/TD]
[TD]Days overdue[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018-09-26[/TD]
[TD]10 000[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-250[/TD]
[TD][/TD]
[TD]overdue > 8-14 days[/TD]
[TD]Due in 15 days[/TD]
[/TR]
[TR]
[TD]2019-05-13[/TD]
[TD]9 434[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-21[/TD]
[TD][/TD]
[TD]Amount?[/TD]
[TD]Amount?[/TD]
[/TR]
[TR]
[TD]2019-05-15[/TD]
[TD]3 053[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-20[/TD]
[TD]6 000[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-23[/TD]
[TD]65 077[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-24[/TD]
[TD]69 350[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-24[/TD]
[TD]2 500[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-27[/TD]
[TD]3 000[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-27[/TD]
[TD]18 253[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-29[/TD]
[TD]40 039[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-05-29[/TD]
[TD]33 108[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]-5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-12[/TD]
[TD]3 153[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-13[/TD]
[TD]39 930[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-13[/TD]
[TD]18 795[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-14[/TD]
[TD]17 000[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-14[/TD]
[TD]37 546[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-17[/TD]
[TD]10 000[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-17[/TD]
[TD]57 219[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-19[/TD]
[TD]3 125[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-19[/TD]
[TD]24 079[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019-06-19[/TD]
[TD]22 216[/TD]
[TD="align: right"]2019-06-03[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1	Due date	Amount	Today	Days overdue	overdue > 8-14 days	Due in 15 days
2	26/09/2018	10,000	03/06/2019	-250	142,927	183,643
3	13/05/2019	9,434	03/06/2019	-21
4	15/05/2019	3,053	03/06/2019	-19
5	20/05/2019	6,000	03/06/2019	-14
6	23/05/2019	65,077	03/06/2019	-11
7	24/05/2019	69,350	03/06/2019	-10
8	24/05/2019	2,500	03/06/2019	-10
9	27/05/2019	3,000	03/06/2019	-7
10	27/05/2019	18,253	03/06/2019	-7
11	29/05/2019	40,039	03/06/2019	-5
12	29/05/2019	33,108	03/06/2019	-5
13	12/06/2019	3,153	03/06/2019	9
14	13/06/2019	39,930	03/06/2019	10
15	13/06/2019	18,795	03/06/2019	10
16	14/06/2019	17,000	03/06/2019	11
17	14/06/2019	37,546	03/06/2019	11
18	17/06/2019	10,000	03/06/2019	14
19	17/06/2019	57,219	03/06/2019	14
20	19/06/2019	3,125	03/06/2019	16
21	19/06/2019	24,079	03/06/2019	16
22	19/06/2019	22,216	03/06/2019	16
List

Cell Formulas
Range	Formula
E2	=SUMIFS(B2:B22,D2:D22,"<=-8",D2:D22,">=-14")
F2	=SUMIFS(B2:B22,D2:D22,">=0",D2:D22,"<=15")

 

[willwall]

Works great, thanks for your help

 

[Fluff]

You're welcome & thanks for the feedback