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.
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.