EXCEL表IF多条件求和??
发布网友
发布时间：2022-04-23 17:07
共1个回答
热心网友
时间：2022-05-02 20:25
输入以下公式
=SUMIFS(C:C,B:B,"长",C:C,">7000")*0.2+SUMIFS(C:C,B:B,"长",C:C,"<7000")*0.1+SUMIFS(C:C,B:B,"短",C:C,">13000")*0.3+SUMIFS(C:C,B:B,"短",C:C,"<13000")*0.25追问不对呢？
追答是方法不对 还是规则有误
