假设数据在A1:M1统计单数列:=sumproduct(n(mod(column(A1:M1),2)*A1:M1>0)) 统计双数列:=sumproduct(n((mod(column(A1:M1),2)=0)*A1:M1>0))