接力赛：连续数值的个数统计

wyywym

<p>78字符</p><p>=SUM(N(FREQUENCY(A$2:C$8,(COUNTIF(A$2:C$8,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

小_笨_笨

<p>75字符</p><p>=SUM(N(FREQUENCY(A$2:C8,(COUNTIF(A$2:C8,ROW($1:88))=0)*ROW($1:88))=ROW()-1))</p>

wjh619993018

<p>73字符，有点慢</p><p>=SUM(N(FREQUENCY(A$2:C8,(COUNTIF(A:C,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

wjh619993018

<p>70字符，一个更慢的</p><p>=SUM(N(FREQUENCY(A:C,(COUNTIF(A:C,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

happyxtbo

<p>学习下！对我来说太难了</p><p><strong><font color="#e70808" size="5">严禁跟贴灌水，否则每贴扣罚20金币，已扣20BB</font></strong></p>

[此贴子已经被tkgg93于2010-8-13 18:15:01编辑过]

小_笨_笨

<p>69字符：</p><p>=SUM(N(FREQUENCY(A:C,(COUNTIF(A:C,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

yuhe0008

<p>13楼怎么回事？公式跟11楼公式一模一样啊</p><p>偷11楼公式再减2个字符，68字符</p><p>=SUM(N(FREQUENCY(A:C,(SUMIF(A:C,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

dengyf

9楼及以下不能算对，如果A到C列非数字区域内有断号出现，会出现错误。

[此贴子已经被作者于2010-8-13 8:30:30编辑过]

yuang68

<p>9楼以下不算对，那我取个巧，改8楼公式少2个字符</p><p>=SUM(N(FREQUENCY(A$2:C$8,(SUMIF(A$2:C$8,ROW($1:99))=0)*ROW($1:99))=ROW()-1))</p>

dengyf

<p>不错，现在最短是75个字符了。</p>