SOLVED

SumifS function with Date Test

Copper Contributor

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

 CD
A2/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.

 

ABC
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 Replies
best response confirmed by SI-DJB (Copper Contributor)
Solution

@SI-DJB 

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

You can try this formula.

sumifs.png 

Your awesome that worked perfect. Thanks
1 best response

Accepted Solutions
best response confirmed by SI-DJB (Copper Contributor)
Solution

@SI-DJB 

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

You can try this formula.

sumifs.png 

View solution in original post