sheee2中a1=INDIRECT("sheet1!B"&ROW()*1+5)
sheee2中a1=INDIRECT("sheet1!B"&ROW()*1+5)
=IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7)
{=indirect("Sheet1!A"&row(1:16))},公式正解.
请教高手这个函数公式=INDIRECT("Sheet1!a"&ROW()*5+10)是什么意思?
请用文字解释这个公式,=SUMPRODUCT(N(INDIRECT("sheet1!E"&(ROW($1:$1063)-
EXCEL中:=SUMPRODUCT(1/(1+A1*ROW(INDIRECT("1:"&A3))))公式成立,如果进行
IF(MOD(ROW(),5),"",INDIRECT("sheet1!a"&ROW()/5) ) 您好,看到您的回答,
VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2:
EXCEL 公式:=INDIRECT("sheet2!"&ADDRESS(ROW(A1),(COLUMN(A1)-1)*
=SUM(LARGE(A1:A10,ROW(INDIRECT(1&":"&COUNTA(A1:A10)*0.2))))/
请一下,您的公式里面=INDIRECT(ADDRESS((ROW(A1)-1)/3+2,MOD(ROW(A1)-1,3)
VLOOKUP(B14,INDIRECT("'cp"&ROW(INDIRECT("1:4"))&"'!b:f"),5,F