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.

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>

Due date	Amount	Today	Days overdue
2018-09-26	10 000	2019-06-03	-250		overdue > 8-14 days	Due in 15 days
2019-05-13	9 434	2019-06-03	-21		Amount?	Amount?
2019-05-15	3 053	2019-06-03	-19
2019-05-20	6 000	2019-06-03	-14
2019-05-23	65 077	2019-06-03	-11
2019-05-24	69 350	2019-06-03	-10
2019-05-24	2 500	2019-06-03	-10
2019-05-27	3 000	2019-06-03	-7
2019-05-27	18 253	2019-06-03	-7
2019-05-29	40 039	2019-06-03	-5
2019-05-29	33 108	2019-06-03	-5
2019-06-12	3 153	2019-06-03	9
2019-06-13	39 930	2019-06-03	10
2019-06-13	18 795	2019-06-03	10
2019-06-14	17 000	2019-06-03	11
2019-06-14	37 546	2019-06-03	11
2019-06-17	10 000	2019-06-03	14
2019-06-17	57 219	2019-06-03	14
2019-06-19	3 125	2019-06-03	16
2019-06-19	24 079	2019-06-03	16
2019-06-19	22 216	2019-06-03	16

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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