=INDIRECT("sheet"&row(a1)&"!h5") 再次请教下该公扩展用法=INDIRECT("sheet"&row(a1)&"!h5") 这个公式中,如果我要将目标表中h5至h10格里的数值之和链接到表格中,这个公式应该如何改动呢?

=SUMIF(INDIRECT(sheet&ROW(1:8)&!B2:B40),A5,INDIRECT(sheet&ROW(1:8)&!E2:E40)) 结果不对 =INDIRECT(INDIRECT(ADDRESS(ROW(),3))) 求解析该函数...想实现两个sheet页的联动效果 =INDIRECT(sheet&ROW(2:2)&!F6)怎么去理解,ROW(2:2)又是什么意思. 请问这个公式 =INDIRECT(Sheet&ROW(A1)&!G1) 里面的A1指的是什么啊,求教. indirect函数详解 =INDIRECT INDIRECT函数=INDIRECT($A17&!&S4) =INDIRECT(sheet&row(a1)&!h5) 再次请教下该公扩展用法=INDIRECT(sheet&row(a1)&!h5) 这个公式中,如果我要将目标表中h5至h10格里的数值之和链接到表格中,这个公式应该如何改动呢? =INDIRECT(A2&!Al18) indirect sheet INDIRECT函数 =INDIRECT($A6&!&V$1&$B6),急, RO =SUM(INDIRECT(B1:B&ROW())), =SUM(INDIRECT(E1:E&ROW()-1)) =(INDIRECT('&$B23&'!&F$1&$D23)) 这个语句不明白,尤其是那个Ts=SUM(SUMIF(INDIRECT('&ROW(INDIRECT(1:&Ts))&'!B:B),B5,INDIRECT('&ROW(INDIRECT(1:&Ts))&'!E:E))) Excel 问题求教育：=INDIRECT(INDIRECT(ADDRESS(ROW(),3))) 求解析该函数... =VLOOKUP(INDIRECT(A5)+2,INDIRECT(H2:I81),2,0),括号中+2如何递增,下来没用.=VLOOKUP(INDIRECT(A5)+3,INDIRECT(H2:I81),2,0)=VLOOKUP(INDIRECT(A5)+4,INDIRECT(H2:I81),2,0).=VLOOKUP(INDIRECT(A5)+39,INDIRECT(H2:I81),2,0)要做十列,3