SumifS function with Date Test

[SI-DJB]

I want to ref 2 dates field to sum totals when found between the to dates.  

	C	D
A	2/10/2023	2/17/2023

For instance:

=SUMIFS(C3:C12,A3:A12,>C3,A3:A12<D3)

Excel does not like the math function <> used on C or D above.

A	B	C
2/3/2023		1
2/4/2023		2
2/5/2023		3
2/6/2023		4
2/7/2023		5
2/8/2023		6
2/9/2023		7
2/10/2023		8
2/11/2023		9
2/12/2023		10

[#2 · Accepted solution]

@SI-DJB 

=SUMIFS(C3:C12,A3:A12,">"&C1,A3:A12,"<"&D1)

You can try this formula.

 

[#3]

Your awesome that worked perfect. Thanks