比如这一行是第一行，=SUMIF(1:1,">5")再如数据在第二行的B列到X列，=SUMIF(B2:X2,">5")
=SUMIF(A1:A10,">5") 公式下拉完成文件发sm100e@qq.com
=SUMIF(A1:A10,">5")
=SUMIF(A2:D2,">5")
