excel删除行怎样能不影响公式引用区域

更新时间2018-05-14 12:47:08

公式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)))