=INDIRECT("sheet"&ROW(2:2)&"!F6")怎么去理解,ROW(2:2)又是什么意思.
=INDIRECT("sheet"&ROW(2:2)&"!F6")怎么去理解,ROW(2:2)又是什么意思.
=INDIRECT("a"&2*ROW()-1)&INDIRECT("a"&2*ROW())求详解,改能里关系到文字位置
=INDIRECT("a"&INT((ROW()-10)/2)+1)这个公式怎么用
=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$2)&"!C:C"),$C5,INDIRECT(R
请一下,您的公式里面=INDIRECT(ADDRESS((ROW(A1)-1)/3+2,MOD(ROW(A1)-1,3)
=MOD(ROW(F6),
=INDIRECT(CONCATENATE("Sheet2!","R",(ROW()-3)/24+2,"C",2),FA
=IF($Q17=0,0,INDIRECT(ADDRESS(ROW(),COLUMN()-2,"仕入_"&$Q17)))
=IF(N2="","",OFFSET(INDIRECT($R$1),ROW()-2,COLUMN()-14))
(ROW()-1)/12+3是什么意思?COLUMN()+2又是什么意思?
请老鸟帮助解释这个公式:=INDIRECT("输入!a"&ROW()*36-2)
求解释在excel中,函数:=INDIRECT("sheet2!A"&((ROW(Sheet2!A2)-2)*20+(C