LZ是做双色球的表?
数据在A1:A6
质数
=SUMPRODUCT(--ISNUMBER(FIND(A1:A6&",","1,2,3,5,7,11,13,17,19,23,29,31,")))
合数,可直接引用质数的单元格
=6-SUMPRODUCT(--ISNUMBER(FIND(A1:A6&",","1,2,3,5,7,11,13,17,19,23,29,31,")))
奇数
=SUMPRODUCT(--MOD(A1:A6,2))
偶数
=SUMPRODUCT(--MOD(A1:A6+1,2))
小数
=COUNTIF(A1:A6,"<17")
大数
=COUNTIF(A1:A6,">=17")
----------
A1:A6 改为实际的数据区
温馨提示:答案为网友推荐,仅供参考