=INDIRECT("c"&6*ROW(B2)-12+COLUMN(B2))

=INDIRECT(c&6*ROW(B2)-12+COLUMN(B2)) 公式=INDIRECT(D$8&!&$C$6&ROW(D13)) 能不能解释一下这个函数的意思 =SUM(INDIRECT(B1:B&ROW())), =SUM(INDIRECT(E1:E&ROW()-1)) 您好 如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,a,) 区域等差 适用于C18：C24等等=IF(AND(COUNTIF(INDIRECT(C&7+ROW(A1)*4):INDIRECT(C&10+ROW(A1)*4),0)=1,COUNTIF(INDIRECT(C&7+ROW(A1)*4):INDIRECT(C&10+ROW(A1)*4),INDIRE 这个语句不明白,尤其是那个Ts=SUM(SUMIF(INDIRECT('&ROW(INDIRECT(1:&Ts))&'!B:B),B5,INDIRECT('&ROW(INDIRECT(1:&Ts))&'!E:E))) VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT(b2:b&ROW($2:$6)),B$9),$C$2:$C$6),2, excel公式求简化!=SUM(COUNTIF(INDIRECT(C&ROW()&:&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{A,E,F}))*10 sheee2中a1=INDIRECT(sheet1!B&ROW()*1+5) 解释一下excel里=INDIRECT(Sheet11!C&INT((ROW(Sheet11!C31)-7)/24)+7)的公式和参数的含义 =INDIRECT(CONCATENATE(Sheet2!,R,(ROW()-3)/24+2,C,2),FALSE) 上面各个符号代表是什么意思呢? {=SUM(vlookup(B2,C1：M5,row(indirect(B3&:&B4))+1,0））}row(indirect(B3&:&B4))+1, =SUMIF(INDIRECT(sheet&ROW(1:8)&!B2:B40),A5,INDIRECT(sheet&ROW(1:8)&!E2:E40)) 结果不对 =INDIRECT(a&2*ROW()-1)&INDIRECT(a&2*ROW())求详解,改能里关系到文字位置啊? excel,如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,a,) 区域等差 适用于C18：C24等等改写了一个公式 进行改写 =IF(SUMPRODUCT(1/COUNTIF(INDIRECT(C&4+ROW(A1)*7):INDIRECT(C&10+ROW(A1)*7),INDIRECT(C&4+ROW(A1)*7):IND Excel 问题求教育：=INDIRECT(INDIRECT(ADDRESS(ROW(),3))) 求解析该函数... =INDIRECT(sheet&ROW(2:2)&!F6)怎么去理解,ROW(2:2)又是什么意思. =indirect( "'6月' d" &row(8:8)) 请问这函数的意思是什么?