Count the number of odd numbers in a row

[Chubster]

Hi,
I could use an assist with a formula that would do the following:

I have a row of values A1:U1 and would like to count the number of odd (or even) values in the row.

The value zero would be considered 'even'.

thank you,
Chubs

[Paul]

Hi Chubster,

This should do the trick. To count the number of ODD values, use:

=SUMPRODUCT(--(MOD(A1:U1,2)=1))

For even, replace the last 1 with a 0.

=SUMPRODUCT(--(MOD(A1:U1,2)=0))

Hope that helps!

[galvinpaddy]

Hi,

Please check the attached and see how that works for you
galvinpaddy

EDIT - Apologies Paul, must have submitted seconds after you

[Chubster]

Paul,
Worked perfectly.
Thank you for the very quick and accurate response!

Rgds,
Chubs