Forum Discussion

SI-DJB's avatar
SI-DJB
Copper Contributor
Sep 05, 2023
Solved

SumifS function with Date Test

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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Sep 05, 2023

    SI-DJB 

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

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 05, 2023

SI-DJB 

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

You can try this formula.

 

SI-DJB's avatar
SI-DJB
Copper Contributor
Sep 05, 2023
Your awesome that worked perfect. Thanks

Resources