EXCEL高手们:请问什么公式可以统计出一列或一行单元格数中有多少个质 ...答: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)...