Mar 24 2022 01:25 AM
Hello Dears
Could you please help regarding the attached test sheet, i need a formula to sumif based on contract date column (E) to be clasified before 2022 and starting from Jan 2022.
Thanks in advance
Mar 24 2022 03:02 AM
SolutionThat's like
=SUMIFS(F$4:F$23,$B$4:$B$23,"*DT-2A-*", $E$4:$E$23, "<" & DATE(2022,1,1) )
Used range shall not cross the cell with formula.
Mar 24 2022 03:02 AM
SolutionThat's like
=SUMIFS(F$4:F$23,$B$4:$B$23,"*DT-2A-*", $E$4:$E$23, "<" & DATE(2022,1,1) )
Used range shall not cross the cell with formula.