SUMIFS if a date is within the range

[CraigG]

Hi

I'm having difficulties and mental block for what should be a simple formula. I'm trying to SUM a column if a date is within a range.

For example:

	A	B	C
1	01/01/2022	31/12/2022	£ 500,000.00
2	01/01/2023	31/12/2023	£10,000.00
3	01/01/2024	31/12/2024	£1.00
4	01/01/2024	31/01/2024	£100.00
5	01/01/2024	31/12/2024	£2.00
6	02/01/2024	01/01/2025	£3.00

Date to check:
Cell A10: 10/03/2024

NB: All dates are in the format DD/MM/YYYY

I need a SUMIF to check if the date in A10 is in the range A:A and B:B then return the sum of C.

So in the example above, the date 10/03/2024 is in the range in rows 3, 5 and 6, So the result of the sum would be £6.00, which is £1.00+£2.00+£3.00.

I've tried numerous SUMIFS, SUMPRODUCT, but I just can't get it right. Can anyone please help! Thanks

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	01/01/2022	31/12/2022	£500,000.00
3	01/01/2023	31/12/2023	£10,000.00
4	01/01/2024	31/12/2024	£1.00
5	01/01/2024	31/01/2024	£100.00
6	01/01/2024	31/12/2024	£2.00
7	02/01/2024	01/01/2025	£3.00
8
9
10	10/03/2024	£6.00
Sheet5

Cell Formulas
Range	Formula
B10	B10	=SUMIFS(C1:C7,A1:A7,"<="&A10,B1:B7,">="&A10)