Sum column based on date range

[rongil20]

Hi, not sure how to best explain what I am after. Happy to do this via VBA or regular formulas.

Essentially what I am after is to sum my amounts by date depending if that number falls within the date range

This is column F in the minisheet.

For example, on the 4th Jan 2022, cell F4. I will have an amount of 231,193,853.93 because it is including the amounts in cells C2 to C5.

I hope that makes sense

Example sheet.xlsx
	A	B	C	D	E	F
1	start date	end date	amount		dates
2	01/01/2022	01/02/2022	100,000,000.00		01/01/2022	100,000,000.00
3	02/01/2022	02/02/2022	29,699,930.60		02/01/2022	129,699,930.60
4	03/01/2022	03/02/2022	64,509,742.49		03/01/2022	194,209,673.09
5	04/01/2022	04/02/2022	36,984,180.83		04/01/2022	231,193,853.93
6	05/01/2022	05/02/2022	51,178,766.15		05/01/2022	282,372,620.07
7	06/01/2022	06/02/2022	16,532,558.20		06/01/2022	298,905,178.27
8	07/01/2022	07/02/2022	45,469,425.79		07/01/2022	344,374,604.06
9					08/01/2022	344,374,604.06
10					09/01/2022	344,374,604.06
11					10/01/2022	344,374,604.06
12					11/01/2022	344,374,604.06
13					12/01/2022	344,374,604.06
14					13/01/2022	344,374,604.06
15					14/01/2022	344,374,604.06
16					15/01/2022	344,374,604.06
17					16/01/2022	344,374,604.06
18					17/01/2022	344,374,604.06
19					18/01/2022	344,374,604.06
20					19/01/2022	344,374,604.06
21					20/01/2022	344,374,604.06
22					21/01/2022	344,374,604.06
23					22/01/2022	344,374,604.06
24					23/01/2022	344,374,604.06
25					24/01/2022	344,374,604.06
26					25/01/2022	344,374,604.06
27					26/01/2022	344,374,604.06
28					27/01/2022	344,374,604.06
29					28/01/2022	344,374,604.06
30					29/01/2022	344,374,604.06
31					30/01/2022	344,374,604.06
32					31/01/2022	344,374,604.06
33					01/02/2022	344,374,604.06
34					02/02/2022	244,374,604.06
35					03/02/2022	214,674,673.46
36					04/02/2022	150,164,930.97
37					05/02/2022	113,180,750.14
38					06/02/2022	62,001,983.99
39					07/02/2022	45,469,425.79
Sheet1

Cell Formulas
Range	Formula
F2	F2	=$C$2
F3	F3	=$C$2+$C$3
F4	F4	=$C$2+$C$3+$C$4
F5	F5	=$C$2+$C$3+$C$4+$C$5
F6	F6	=$C$2+$C$3+$C$4+$C$5+$C$6
F7	F7	=$C$2+$C$3+$C$4+$C$5+$C$6+$C$7
F8:F33	F8	=$C$2+$C$3+$C$4+$C$5+$C$6+$C$7+$C$8
E9:E39	E9	=E8+1
F34	F34	=$C$3+$C$4+$C$5+$C$6+C7+C8
F35	F35	=C4+C5+C6+C7+C8
F36	F36	=C5+C6+C7+C8
F37	F37	=C6+C7+C8
F38	F38	=C7+C8
F39	F39	=C8

 

[jasonb75]

In F2, fill down to the end.

=SUMIFS($C$2:$C$8,$A$2:$A$8,"<="&E2,$B$2:$B$8,">="&E2)

 

[rongil20]

Thanksm worked a charm