formula help

[hussein_elsayed]

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

[#2 · Accepted solution]

@hussein_elsayed 

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.

[#3]

Thank you so much Mr. Sergei, i got it

[#4]

@hussein_elsayed , you are welcome