Count even and odd numbers?

adjust your range as required

Please Login or Register  to view this content.

Originally Posted by daddylonglegs

....but if you might have blanks in the range....

=COUNT(A1:A100)-SUMPRODUCT(MOD(A1:A100,2))&"E - "&SUMPRODUCT(MOD(A1:A100,2))&"O"

What I'ld like to do after giving it some thought is to have the odd numbers font color red, and the even numbers font color blue. I would like to have this condition right in the 5 columns that I enter the values for the lotto5 picks. I don't have any formulas bound to those columns, but I do call on the value of those cells with several other functions in different columns. I would also like to count the number of red font odd numbered items in each column and return that to a cell, and the same with the blue font even numbered items for each column. The reason for this if the total number of evens are lagging behind the odds(or visa-versa) but doesn't reflect that at the top of the column where I'll be looking for the latest odd/even probability. This will help make the call weather this columns next number will be even or odd. The odd/even check is very helpful for selecting numbers.

Tom

Originally Posted by duane

adjust your range as required

Please Login or Register  to view this content.

Thanks Duane,

That works perfectly! I'm using this formula

Please Login or Register  to view this content.

to count the totals of each..... that's because I have 163 rows at present.

Tom

Checking this formula on smaller amount of cells it appears the Count pre-fix messes things up... The formula works as

Please Login or Register  to view this content.

Just like you originally said!

Why I asked......

Please Login or Register  to view this content.

With this data I see Column 3 pretty much has to be an odd number. In Column 5 the long history shows even numbers are lagging, but the E/O in the short history are balanced????? Can this "deviance" be trapped in time or is thee a potentual for a "catch up" for the "E's" in the future?


Col1 is probably an even, col2 is probably an even, col3 almost has to be an even, col4 is probably an even, and col5 I think will be an odd... slim chance of all 5 numbers being all even.