excel删除行怎样能不影响公式引用区域
公式1=COUNTIF(Z$40:Z$500,"=10")
公式 2 =COUNT(0/(FREQUENCY(IF(Z$41:Z$500=10,ROW($40:$499)),IF(Z$41:Z$500<>10,ROW($40:$499)))>=ROW(A2)))
=COUNTIF(Z$40:OFFSET(Z$40,460,),"=10")
=COUNT(0/(FREQUENCY(IF(Z$41:OFFSET(Z$41,460,)=10,ROW($40:$498)),IF(Z$41:OFFSET(Z$41,460,)<>10,ROW($40:$498)))>=ROW(A2)))
热门标签: