请高手为我解答EXCEL函数问题,谢谢!

2024-12-24 17:55:59
推荐回答(2个)
回答1:

H1录入公式:
=SUMIF(A1,">2")+SUMIF(C1:G1,">2")
回车
按住填充柄下拉复制公式。

回答2:

=SUMIF(A1:G1,">2")-B1