count and return pair numbers
Thank you very much Mike
It works, Much appriciated
Sly
"Mike H" wrote:
If blanks are an issue then use this for even numbers
=SUMPRODUCT(--(A1:A10<""),--(MOD(A1:A10,2)=0))
or in fact a similar one for odd numbers but the previous isn't affected by
blanks
=SUMPRODUCT(--(A1:A10<""),--(MOD(A1:A10,2)=1))
Mike
Mike
"Sly" wrote:
Sorry I will reformulate
I'm looking to find out how many cell in a row contain an even number
row1 = 2 4 8 11 15 16
Looking for a formula that will tell me (4) cells have even number
"Mike H" wrote:
Perhaps odd and even numbers?
=SUM(MOD(A1:A10,2))
=SUM(IF(MOD(A1:A10,2)=0,1,0))
The top formula returns odd number, the other returns even
Both are array formula so Ctrl+Shidt+enter
Mike
"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
|