连续偶数的次数
=SUM(N(FREQUENCY(IF(MOD(A$1:A$17,2)=0,ROW(A$1:A$17)),IF(MOD(A$1:A$17,2),ROW(A$1:A$17)))=ROW(A1))) 数组公式,ctrl+shift+enter结束,下拉公式.
这样处理不能扩大范围为A1:E17,只能一列一列,最后把这几列的数据相加就可以了.
连续奇数的次数（把五列全部相加的公式）,F19输入公式
=SUM(N(FREQUENCY(IF(MOD(A$1:A$17,2),ROW(A$1:A$17)),IF(MOD(A$1:A$17,2)=0,ROW(A$1:A$17)))=ROW(A1)))+SUM(N(FREQUENCY(IF(MOD(B$1:B$17,2),ROW(A$1:A$17)),IF(MOD(B$1:B$17,2)=0,ROW(A$1:A$17)))=ROW(A1)))+SUM(N(FREQUENCY(IF(MOD(C$1:C$17,2),ROW(A$1:A$17)),IF(MOD(C$1:C$17,2)=0,ROW(A$1:A$17)))=ROW(A1)))+SUM(N(FREQUENCY(IF(MOD(D$1:D$17,2),ROW(A$1:A$17)),IF(MOD(D$1:D$17,2)=0,ROW(A$1:A$17)))=ROW(A1)))+SUM(N(FREQUENCY(IF(MOD(E$1:E$17,2),ROW(A$1:A$17)),IF(MOD(E$1:E$17,2)=0,ROW(A$1:A$17)))=ROW(A1)))
数组公式,ctrl+shift+enter结束,下拉公式.