请教一个公式 用简单公式替换复杂的,不要数组公式 =COUNTIF('1'!$AA57:$AN57,'1'!BE54) +COUNTIF('2'!$AA57:$AN57,'2'!BE54) +COUNTIF('3'!$AA57:$AN57,'3'!BE54) +COUNTIF('4'!$AA57:$AN57,'4'!BE54) +COUNTIF('5'!$AA57:$AN57,'5'!BE54) +COUNTIF('6'!$AA57:$AN57,'6'!BE54) +COUNTIF('7'!$AA57:$AN57,'7'!BE54) +COUNTIF('8'!$AA57:$AN57,'8'!BE54) +COUNTIF('9'!$AA57:$AN57,'9'!BE54) +COUNTIF('10'!$AA57:$AN57,'10'!BE54) +COUNTIF('11'!$AA57:$AN57,'11'!BE54) +COUNTIF('12'!$AA57:$AN57,'12'!BE54)+ COUNTIF('13'!$AA57:$AN57,'13'!BE54) +COUNTIF('14'!$AA57:$AN57,'14'!BE54) +COUNTIF('15'!$AA57:$AN57,'15'!BE54) +COUNTIF('16'!$AA57:$AN57,'16'!BE54) +COUNTIF('17'!$AA57:$AN57,'17'!BE54) +COUNTIF('18'!$AA57:$AN57,'18'!BE54) +COUNTIF('19'!$AA57:$AN57,'19'!BE54) +COUNTIF('20'!$AA57:$AN57,'20'!BE54)
=SUM(COUNTIF(INDIRECT(ROW($1:$20)&"!$AA57:$AN57"),BE54))只能提供一个数组的了,不是数组的等高手来吧
|