=INDIRECT($E$24&"!H"&MATCH(CONCATENATE($C$24,$E$24,$G$24,$C$21),INDIRECT($E$24&"!F:F"),0))

=INDIRECT($E$24&!H&MATCH(CONCATENATE($C$24,$E$24,$G$24,$C$21),INDIRECT($E$24&!F:F),0)) =SUM(INDIRECT(E1:E&ROW()-1)) EXCEL高手解释下下面这个公式什么意思.=INDIRECT($E$24&!l&MATCH(CONCATENATE($C$24,$E$24,$G$24,$C$21),INDIRECT($E$24&!F:F),0))举几个INDIRECT和MATCH组合运用的例子 这个语句不明白,尤其是那个Ts=SUM(SUMIF(INDIRECT('&ROW(INDIRECT(1:&Ts))&'!B:B),B5,INDIRECT('&ROW(INDIRECT(1:&Ts))&'!E:E))) EXCEL公式分析=IF(A4=品名,,IF(ISERROR(INDIRECT(H$2&!a1)),,SUMIF(INDIRECT(H$2&!3:3),$A4,INDIRECT(H$2&!15:15)))) indirect函数详解 =INDIRECT 这个Excel公式是什么意思?=SUMIF(INDIRECT(AA$1&!&$E:$E),$E4,INDIRECT(AA$1&!&$J:$J)) INDIRECT函数=INDIRECT($A17&!&S4) EXCEL公式的意义,=(SUMPRODUCT((INDIRECT(原始数据!B&$B$3&:B&$B$4)>300)*(INDIRECT(原始数据!h&$B$3&:h&$B$4)>300)*(INDIRECT(原始数据!n&$B$3&:n&$B$4)300)*(INDIRECT(原始数据!h&$B$3&:h&$B$4)300)*(INDIRECT(原始数据!AD =INDIRECT(A2&!Al18) indirect {=COUNTIF(OFFSET($I$9:$K$9,ROW(INDIRECT(1:&COUNTA($H$9:$H$11)))),)} 函数中的表示什么? =VLOOKUP($A6,INDIRECT(E$1&"!C:F"),4,0) INDIRECT函数 =INDIRECT($A6&!&V$1&$B6),急, 请用文字解释这个公式,=SUMPRODUCT(N(INDIRECT(sheet1!E&(ROW($1:$1063)-1)*35+25))) SUMIF(INDIRECT(F$2&!&$H:$H),$A11,INDIRECT(F$2&!&$F:$F)),谁能帮我解释一下这个EXCEL语句 SUMPRODUCT((MOD('3'!$E$5:$E$100,1)>=1/3)*(MOD('3'!$E$5:$E$100,1)=1/3)*(MOD('4'!$E$5:$E$100,1)=1/3)*(MOD(INDIRECT(ROW(A3)&!$E$5:$E$100),1) IF(ISNA(INDEX(INDIRECT('&$A5&'!&CHAR(COLUMN()+68)&:&CHAR(COLUMN()+68)),MATCH($B$3,INDIRECT('&$A5&'!$E:$E),0))),0,INDEX(INDIRECT('&$A5&'!&CHAR(COLUMN()+68)&:&CHAR(COLUMN()+68)),MATCH($B$3,INDIRECT('&$A5&'!$E:$E),0)))