{=COUNTIF(OFFSET($I$9:$K$9,ROW(INDIRECT("1:"&COUNTA($H$9:$H$
{=COUNTIF(OFFSET($I$9:$K$9,ROW(INDIRECT("1:"&COUNTA($H$9:$H$
VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2:
在定义名称里有这个=COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:12"))&"月'!A2:
=SUM(LARGE(A1:A10,ROW(INDIRECT(1&":"&COUNTA(A1:A10)*0.2))))/
=MOD(-LARGE(COUNTIF($B2:$D6,ROW($1:$9))*10-ROW($1:$9),COLUMN
=IF(N2="","",OFFSET(INDIRECT($R$1),ROW()-2,COLUMN()-14))
=SUBTOTAL(9,OFFSET(N$5,COUNTA($C:$C)))这个公式什么意思
=IF(ISBLANK(B177),"",COUNTA(OFFSET(B177,-ROW(B177)+2,0,ROW()
=COUNTIF((OFFSET(INDIRECT($A$3&"!"&$B6),14,COUNTIF(各部门综合!$A:
=SUM(OFFSET(AD4709,COUNTA($1:$1)-8))那个COUNTA($1:主要不懂counta($
ROUND(OFFSET(D52,(COUNTA(U52:address(row(),21))-1)*2,13,1,1)
=IF(COUNTIF(INDIRECT("N1:N"&ROW()),N2)=1,1,0)问一下这个公式的意思