在Excel数据库中,如B2:B10区域中是某单位职工的工龄,C2:C10区域中是职
5 查阅
=SUMIF(B2:B10,">5",C2:C10)
=E112=SUMIF(C2:C10,">5",B2:B10)
=sumif(c2:c10,b2:b10,">5")
=sumif(b2:b10,c2:c10,">5")
参考答案:
=SUMIF(B2:B10,">5",C2:C10)
=E112=SUMIF(C2:C10,">5",B2:B10)
=sumif(c2:c10,b2:b10,">5")
=sumif(b2:b10,c2:c10,">5")
参考答案: