Sum using lookup reference

[PolarOath]

Hi All,

I wasn't quite able to find an answer to this. I'm trying to sum a range in a column based on a start and end date; though not quite sure how the formula would look.

For example
Start date: 12/11/2022 6:00:00 AM
End date: 13/11/2022 7:50:00 AM

The formula should then lookup the start/end dates in column A and then sum up the range of values in column L between those times.
I've figured out how to return the row number via

=MATCH(AG55,A:A,0)

(AG55 is the start date reference) though not sure how to implement it within the sum formula.

 

[kevin9999]

In the demo below, change F2 to AG55 and F3 to whatever cell you have the end date in.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date											Value
2	8/11/2022				Start Date:	12/11/2022						153
3	9/11/2022				End Date:	13/11/2022						157
4	10/11/2022											154
5	11/11/2022				formula:	1732						183
6	12/11/2022											140
7	12/11/2022											155
8	12/11/2022											174
9	12/11/2022											136
10	12/11/2022											191
11	12/11/2022											100
12	12/11/2022											132
13	13/11/2022											189
14	20/11/2022											129
15	21/11/2022											106
16	22/11/2022											133
17	23/11/2022											173
18	24/11/2022											184
19	13/11/2022											181
20	13/11/2022											181
21	13/11/2022											153
22
Sheet1

Cell Formulas
Range	Formula
F5	F5	=SUMIFS(L:L,A:A,">="&F2,A:A,"<="&F3)

 

[PolarOath]

In the demo below, change F2 to AG55 and F3 to whatever cell you have the end date in.

Fantastic, this worked like a charm, thanks very much!

 

[kevin9999]

Fantastic, this worked like a charm, thanks very much!

Happy to help & welcome to the Forum