Formula To Create Data Between Dates

[robertsgw]

Hello. I am sure this is easy to do, but I can't figure it out. I tried using a sumifs formula and it didn't work. Each month for up to a year has a value. On the picture I attached you will see for each month there is a value. I want to write a formula that will sum the data between 01/01/2024 and 05/01/2024. Thanks for the help.

 

[Joe4]

Like this:

Formula in cell F3:

=SUMIFS(C1:C12,A1:A12,">="&F1,B1:B12,"<="&F2)

 

[Bosquedeguate]

Book2
	A	B	C	D	E
1	1/1/2023	1/31/2023	2	Date 1	Date 2
2	2/1/2023	2/28/2023	3	12/31/2022	6/1/2023
3	3/1/2023	3/31/2023	4	SUM	20
4	4/1/2023	4/30/2023	5
5	5/1/2023	5/31/2023	6
Sheet1

Cell Formulas
Range	Formula
E3	E3	=SUMIFS(C1:C5,A1:A5,">"&D2,A1:A5,"<" &E2)