Count even and odd numbers?

[farmerTom]

I'm trying to make a spread sheet that helps me select lottery numbers. I want to be able to count all the even/odd numbers in a column then return the total of each in a single column like this:

"67E - 74O"

This is a single condition of many to help me make a selection for my lottery numbers. Maybe an IF condition & divide by 2 with or without a remainder would work but I can't figure this one out.

Tom

[duane]

adjust your range as required

=SUMPRODUCT((MOD(A1:A10,2)=0)*1)&"E"&" "&SUMPRODUCT((MOD(A1:A10,2)<>0)*1)&"O"

[farmerTom]

adjust your range as required

=SUMPRODUCT((MOD(A1:A10,2)=0)*1)&"E"&" "&SUMPRODUCT((MOD(A1:A10,2)<>0)*1)&"O"

Thanks, I put it in my formula text and will install it later!

[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"

[farmerTom]

....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

[farmerTom]

adjust your range as required

=SUMPRODUCT((MOD(A1:A10,2)=0)*1)&"E"&" "&SUMPRODUCT((MOD(A1:A10,2)<>0)*1)&"O"

Thanks Duane,

That works perfectly! I'm using this formula

=COUNT(B1:B163)-SUMPRODUCT((MOD(B1:B163,2)=0)*1)&"E"&" "&SUMPRODUCT((MOD(B1:B163,2)<>0)*1)&"O"

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

=SUMPRODUCT((MOD(B1:B163,2)=0)*1)&"E"&" "&SUMPRODUCT((MOD(B1:B163,2)<>0)*1)&"O"

Just like you originally said!

[farmerTom]

Why I asked......

2E  4O	  2E  4O   1E  5O   2E  4O   3E  3O
 5E  5O	  4E  6O   3E  7O   4E  6O   7E  3O
14E 16O	 15E 15O  15E 15O  12E 18O  17E 13O
87E 76O	 77E 86O  75E 88O  84E 79O  74E 89O

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.