INDIRECT($A$1&"!a"&ROW(2:2)),那双引号是什么一回事？怎么会放在哪里呢

哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&月!$A$1),MATCH(NB R&D allocation,INDIRECT(B$1&月!A:A),0)-1,1,1),2,2,MATCH(Total NB R&D expense,INDIRECT(B$1&月!A:A),0)-MATCH( 哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&月!$A$1),MATCH(NB R&D allocation,INDIRECT(B$1&月!A:A),0)-1,1,1),2,2,MATCH(Total NB R&D expense,INDIRECT(B$1&月!A:A),0)-MATCH( =INDIRECT(a&2*ROW()-1)&INDIRECT(a&2*ROW())求详解,改能里关系到文字位置啊? =VLOOKUP($R$9,INDIRECT($A$16),COLUMN(),FALSE) 我知道VLOOKUP的简单用法, INDIRECT($A$1&!a&ROW(2:2)),那双引号是什么一回事？怎么会放在哪里呢 关于EXCEL中,INDIRECT和MATCH函数的使用IF($A5=,,INDIRECT('&B$2&'!C&MATCH(合 计,INDIRECT('&B$2&'!A&MATCH($A5,INDIRECT('&B$2&'!A1:A541),0)&:A541),0)+MATCH($A5,INDIRECT('&B$2&'!A1:A541),0)-1))麻烦帮忙解释下 在定义名称里有这个=COUNTIF(INDIRECT('&ROW(INDIRECT(1:12))&月'!A2:A10001),普通公式汇总!$A$2) =INDIRECT(a&INT((ROW()-10)/2)+1)这个公式怎么用 请问高手为何公式=INDIRECT(2-&ROW(A1)&!$A$1)会报错呢? EXCEL编公式大神帮我看下呗我们之前的公式代码是这样的：=IF(ISERROR(MATCH($D3,INDIRECT(E3&!$D$2:$D$652),0)),OFFSET(INDIRECT(E3&!$A$1),MATCH(MID($D3,1,9),INDIRECT(E3&!$D$2:$D$652),0),1),OFFSET(INDIRECT(E3&!$A$1),MATCH($D3, lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&!$B$2:$B$59),INDIRECT($A$2&!&CHAR(74+COLUMN())&$2:&CHAR(75+COLUMN())&$59))-LOOKUP($B3,INDIRECT($B$1&!$B$2:$B$59),INDIRECT($B$2&!&CHAR(74+COLUMN())&$2:&CHAR 您好 如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,a,) 区域等差 适用于C18：C24等等=IF(AND(COUNTIF(INDIRECT(C&7+ROW(A1)*4):INDIRECT(C&10+ROW(A1)*4),0)=1,COUNTIF(INDIRECT(C&7+ROW(A1)*4):INDIRECT(C&10+ROW(A1)*4),INDIRE EXCEL公式少了前面的SUM会有什么不同=SUM(SUMIF(INDIRECT({1,2,3}&月!A:A),$A2,INDIRECT({1,2,3}&月!B:B))) excel 能详细讲解下这个indirect函数的用法吗?比如INDIRECT(a&5*(ROW()-1)+COLUMN()-1)是什么意思?其中a列是一列数据.先谢谢了! EXCEL ｛=IF(OR($A9=0,$E9=0,S=0,$N9>S$7,$K9=SUM($R9:R9)),IF(L=1,MIN($K9-SUM($R9:R9),$M9,$J9*SS),IF(SUM(S8:INDIRECT(T&(M+ROW($A$8)))/$J8:INDIRECT(J&(M+ROW($A$8))))*1/SS>=1,MIN((1-SUM(S8:INDIRECT(T&(M+ROW($A$8)))/$J8:INDIRECT(J&(M+ROW($A$8))))*1/SS indirect 谁能帮我解释解释这两个excel公式的实际意义,=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$12)&月!F:F),B6,INDIRECT(ROW($1:$12)&月!R:R))) =SUMPRODUCT(COUNTIF(INDIRECT(ROW($1:$12)&月!F:F),B6)) A. Putting direct speech into indirect speech:21. Putting direct speech into indirect speech:(1) Scientists say, “The earth moves round the sun.” (2) The teacher asked me, “Have you finished your work yet?:” (3) “Why didn’t you come