老师辛苦了
B03:smuggled
第一题- =INDIRECT("A"&ROW(1:4)*3+4)
复制代码 第二题- =SUM(SUMIF(INDIRECT(ROW($1:$3)&"!a:a"),A22,INDIRECT(ROW($1:$3)&"!c:c")))/SUM(COUNTIF(INDIRECT(ROW($1:$3)&"!a:a"),A22))
复制代码 第三题- =SUM((N(INDIRECT({1,2,3}&"!F"&ROW($3:$15)))=A31)*(T(INDIRECT({1,2,3}&"!g"&ROW($3:$15)))=B31)*N(INDIRECT({1,2,3}&"!h"&ROW($3:$15))))
复制代码 |