=INDIRECT($C6&"!$b$3:$b"&2+MATCH("*",INDIRECT($C7&"!$b$3:$b$
INDIRECT(CONCATENATE("常数!d",($B$2+2))
=SUM(INDIRECT("B1:B"&ROW())),
公式 =INDIRECT($B$3&"!"&"C"&ROW(3:3)+5)&"" 帮我解释一下是什么意思
谁能看懂这个函数公式吗?=INDIRECT(CONCATENATE("汇总表!B",1+ROW()*3),TRUE)
sheee2中a1=INDIRECT("sheet1!B"&ROW()*1+5)
VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2:
VLOOKUP(B14,INDIRECT("'cp"&ROW(INDIRECT("1:4"))&"'!b:f"),5,F
VLOOKUP(B6,INDIRECT(--MID(B6,FIND("-",B6)+1,2)&"!b:c"),2,0)谁
=SUM(INDIRECT("B1:B"&ROW())),如果100-(b1+b2),100-(b1+b2+b3),以次
请问EXCEL中“=INDIRECT(CONCATENATE("Sheet2!",ADDRESS((B6-TRUNC(B
表格函数b=indirect(a1&"!a1")代表什么意思,能具体解释下&"!a1"更好.还有c=indirect(a
谁知道这个公式是什么意思{=MIN(IF(COUNTIF(C$1:C1,B$1:B$49)=0,ROW(INDIRECT