count and return pair numbers

[Guest]

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

 

[Guest]

What is your definition for pair and impair numbers?

 

[Guest]

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

 

[Guest]

sorry

odd numbers = 2

Even numbers = 4

What is your definition for pair and impair numbers?

 

[Guest]

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

 

[Guest]

Which for a range with no blank cells is exacly what the 2 formula I have
given you will do.

Mike

 

[Guest]

Sorry Mike

Don't want to waste your time but I try it does'nt work

Thank you very much for your time

Sly

 

[Guest]

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

 

[Rick Rothstein \(MVP - VB\)]

Try these formulas...

Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1))

Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0))

Rick

 

[Guest]

Thank you very much Mike

It works, Much appriciated

Sly

 

[Guest]

Try this:

For Even numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=0))

For Odd numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=1))

 

[Rick Rothstein \(MVP - VB\)]

I think the problem is the OP asked for numbers in a row and your formulas
were for numbers in a column... I'm not sure he sees the difference.

Rick

 

[Rick Rothstein \(MVP - VB\)]

Try these formulas...

Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1))

Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0))

Mike raises a good point about blanks. Here are revisions to the above which
will account for the blanks...

Odd: =SUMPRODUCT((A1:F1<>"")*(MOD(A1:F1,2)=1))

Even: =SUMPRODUCT((A1:F1<>"")*(MOD(A1:F1,2)=0))

Rick

 

[Sandy Mann]

Rick,

Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1))

You don't need the =1, (--(MOD(A1:F1,2) returns 0 or 1 anyway

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Rick Rothstein \(MVP - VB\)]

Good point! Thanks for noting that.

Rick

Rick,


You don't need the =1, (--(MOD(A1:F1,2) returns 0 or 1 anyway

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk