SUM(OFFSET($D$1,(ROW()-1)*2,2))
SUM(OFFSET($D$1,(ROW()-1)*2,2))
OFFSET COLUMN OFFSET($A$1,COLUMN()-2,为什么在row的位置填column?
=OFFSET(Sheet2!$M$2,(ROW(Q1)-1)/2,MOD(ROW(Q1)-1,2))
=SUM(OFFSET($F16:$F45,0,(COLUMN(A1)-1)*2))
关于excel的问题,请问SUM(OFFSET($A$2,(ROW(A3)-2)*7,
=OFFSET($A$1,INT((ROW(A7)-1)/3),MOD(ROW(A7)+2,3))每一项是什么意思
ROUND(OFFSET(D52,(COUNTA(U52:address(row(),21))-1)*2,13,1,1)
=OFFSET($A$1,ROW(A1)+MATCH($J$10,$A$1:$A$10000,)-2,COLUMN(A1
excel中公式"=offset($A$1,column()-2+(row()-1)*4,0)"起什么作用?
=IF(N2="","",OFFSET(INDIRECT($R$1),ROW()-2,COLUMN()-14))
=OFFSET(原始表格!$A$2,MOD(ROW(13:13),13)+1,)
请问:=SUMPRODUCT(N(OFFSET(A1,ROW(1:200)*5-5,))*N(OFFSET(A2,ROW