【函高201501】第五讲B组作业上交贴[开贴]

smuggled

老师辛苦了

B03:smuggled
第一题

1. =INDIRECT("A"&ROW(1:4)*3+4)

复制代码

第二题

1. =SUM(SUMIF(INDIRECT(ROW($1:$3)&"!a:a"),A22,INDIRECT(ROW($1:$3)&"!c:c")))/SUM(COUNTIF(INDIRECT(ROW($1:$3)&"!a:a"),A22))

复制代码

第三题

1. =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))))

复制代码