count and return pair numbers
Try this:
For Even numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=0))
For Odd numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=1))
"Sly" wrote:
What function can I use to return the number of pair or impair numbers in a
row
A B C D E F
Row 1 2 6 9 11 16 20 Pair number = 4
Impair number = 2
Thanks
Sly
|