I want to ref 2 dates field to sum totals when found between the to dates. CDA2/10/20232/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. ABC2/3/2023 12/4/2023 22/5/2023 32/6/2023 42/7/2023 52/8/2023 62/9/2023 72/10/2023 82/11/2023 92/12/2023 10

SI-DJB =SUMIFS(C3:C12,A3:A12,">"&C1,A3:A12,"<"&D1)You can try this formula.

Forum Discussion

Copper Contributor

Sep 05, 2023

Solved

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.

OliverScheurich
Sep 05, 2023
SI-DJB
=SUMIFS(C3:C12,A3:A12,">"&C1,A3:A12,"<"&D1)
You can try this formula.