你好,在线吗?想请你帮个忙,关于excel表格的问题答:用多组判断相加吧,像: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))...