EXCEL条件求和函数,指定条件为小于某单元格

2025-03-09 13:01:15
推荐回答(2个)
回答1:

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

回答2:

=SUMPRODUCT((C1:C10)*(D1:D10=D2)*(B1:B10=B2))

=SUMPRODUCT((C1:C10)*(D1:D10=D2)*(B1:B10