Get sales data for last year but in the next 12 weeks of todays date

Hi Excelenthusiast223 ,

Edit: You are right. I completely misread your initial description of the problem. Have corrected the formula.

=SUMIFS($G$1:$G$119239,$A$1:$A$119239,">"&EDATE($N$1,-9),$F$1:$F$119239,K5)

Note that -9 comes from -12 months (one year) + 3 months (14 weeks as desired) = -9.

By the way: I have made the formula with the reference to a "Today's date" cell because using the function TODAY() would make the formulation change each day. I thought it is more convenient to use a reference to a manual-entry-cell for better or more convenient analysis purposes.