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

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