本帖最后由 yjeeee 于 2015-8-18 21:26 编辑
补交一下,绝对没有看开贴内容
D08:YJEEEE
第1题:- =TRANSPOSE(IF(N(INDIRECT("A"&{1,4,7,10}+6))=0,"",N(INDIRECT("A"&{1,4,7,10}+6)))&T(INDIRECT("A"&{1,4,7,10}+6)))
复制代码 第2题:- =SUM(SUMIF(INDIRECT(ROW($1:$3)&"!A3:A5"),A22,INDIRECT(ROW($1:$3)&"!C3:C5")))
复制代码 第3题:- =SUM(SUMIFS(INDIRECT(ROW($1:$3)&"!H2:H15"),INDIRECT(ROW($1:$3)&"!F2:F15"),A31,INDIRECT(ROW($1:$3)&"!G2:G15"),B31))
复制代码 |