Dates in SUMIFS formula

[samerf86]

Hi,

This is a sample of the data entry sheet.
In another sheet, I am writing a SUMIFS formula to calculate the quantity based on the item, its phase and date.
The problem occurs when I am trying to calculate the quantities of previous dates: ex: SUMIFS(Qtyrange,Itemrange,X,Phaserange,Y,Daterange,<Sep-20)
What should I write in the Date Criteria for the formula to take into consideration all the months previous to Sep-20?

Appreciate your help guys.

 

[samerf86]

It worked ("<"&$J$1), thanks a lot.
When I type Oct-2020, Excel recognizes the year and considers the date as 1-Oct-2020.