Summing all numbers that are between start and end date?

[des378]

This is probably very simple, but for the life of me I can't seem to figure out. I have a list of dates and corresponding amounts. Trying to sum all values where one date falls in between start date (3 months for example, prior to end date) and end date

Ex:

SELECTED DATE: 2024-9-14


Start Date (3 months before End Date) / END DATE / AMOUNT
2024-07-16 / 2024-10-16. / 100
2024-08-19 / 2024-11-19 / 250
2025-07-19 / 2025-10-19 / 100

TOTAL should be: 350
(selected date - the month (e.g 9) falls in between two start and end dates)


Apologies for the lack of spacing in my example - the formatting got messed up when I copied and pasted.

Thanks in advance!

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F
1	Start Date	End Date	Amount		Selected Date	Sum between start and end dates
2	7/16/2024	10/16/2024	100		9/14/2024	350
3	8/19/2024	11/19/2024	250
4	7/19/2025	10/19/2025	100
5
Sheet13

Cell Formulas
Range	Formula
F2	F2	=SUMIFS(C2:C10,A2:A10,"<="&E2,B2:B10,">="&E2)

 

[NickFru]

Hi - you could also try in F2;

=SUMPRODUCT((C2:C10)*(A2:A10<=E2)*(B2:B10>=E2))