用多组判断相加吧,像:
Sheet2的B3输入
=SUM(IF(Sheet1!$C4=B$2,Sheet1!$B4,0),IF(Sheet1!$E4=B$2,Sheet1!$D4,0)+IF(Sheet1!$G4=B$2,Sheet1!$F4,0),IF(Sheet1!$I4=B$2,Sheet1!$H4,0),IF(Sheet1!$K4=B$2,Sheet1!$J4,0),IF(Sheet1!$M4=B$2,Sheet1!$L4,0))
回车并向右和向下填充。
追问后面的怎么设?麻烦详细给解释一下
追答给你个综合公式看看:
Sheet2的B3输入
=SUMIF(Sheet1!$C4:$M4,B$2,Sheet1!$B4:$L4)
回车并向右和向下填充。
后面还有数据的:前一个参数和后一个参数的引用区域间隔扩大。
给你扩大到Y列吧:
=SUMIF(Sheet1!$C4:$Y4,B$2,Sheet1!$B4:$X4)