formula help


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

3 Replies
best response confirmed by hussein_elsayed (Contributor)


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

Thank you so much Mr. Sergei, i got it

@hussein_elsayed , you are welcome