=SUMIFS(C1:C10,D1:D10,D2,B1:B10,"<" & B2)
=SUMPRODUCT((C1:C10)*(D1:D10=D2)*(B1:B10=B2))=SUMPRODUCT((C1:C10)*(D1:D10=D2)*(B1:B10