如图
温馨提示:答案为网友推荐,仅供参考
第1个回答 2018-11-22
C3中输入
=SUMIF(C$10:C$22,--RIGHT($B3),C$12:C$24)
下拉,右拉。
=SUMIF(C$10:C$22,--RIGHT($B3),C$12:C$24)
下拉,右拉。
第2个回答 2018-11-22
类型1汇总金额:
=SUM(SUMIF(C10:I10,1,C12:I12),SUMIF(C14:I14,1,C16:I16),SUMIF(C18:I18,1,C20:I20),SUMIF(C22:I22,1,C24:I24))
类型2汇总金额:
=SUM(SUMIF(C10:I10,2,C12:I12),SUMIF(C14:I14,2,C16:I16),SUMIF(C18:I18,2,C20:I20),SUMIF(C22:I22,2,C24:I24))
类型3汇总金额:
=SUM(SUMIF(C10:I10,3,C12:I12),SUMIF(C14:I14,3,C16:I16),SUMIF(C18:I18,3,C20:I20),SUMIF(C22:I22,3,C24:I24))本回答被网友采纳
=SUM(SUMIF(C10:I10,1,C12:I12),SUMIF(C14:I14,1,C16:I16),SUMIF(C18:I18,1,C20:I20),SUMIF(C22:I22,1,C24:I24))
类型2汇总金额:
=SUM(SUMIF(C10:I10,2,C12:I12),SUMIF(C14:I14,2,C16:I16),SUMIF(C18:I18,2,C20:I20),SUMIF(C22:I22,2,C24:I24))
类型3汇总金额:
=SUM(SUMIF(C10:I10,3,C12:I12),SUMIF(C14:I14,3,C16:I16),SUMIF(C18:I18,3,C20:I20),SUMIF(C22:I22,3,C24:I24))本回答被网友采纳