单项选择题

A.=SUMPRODUCT(B4:C4,B10:C10)+D4-E4
B.=SUMPRODUCT(B4:C4,B10:C10)-D4+E4
C.=B4*B10+C4*C10+D4-E4
D.=SUMPRODUCT(B4:C4,$B$10:$C$10)+D4-E4