Comments for "Excel Formula - Count Number Even & Odd in Cell Range"
April 13, 2010, 1:10 pmExcel Formula - Count Number Even & Odd in Cell Range
These Excel formulas will count the number of Even Numbers and Odd Numbers in a cell range.
For example: Pick 3
You have Position 1 (A1), Position 2 (B1), Position 3 (C1)
Enter the following formula in cell D1 to count the number of "Even Digits in cell range A1 through C1
=COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))
Enter the following formula in cell E1 to count the number of "Odd Digits in cell range A1 through C1
=SUMPRODUCT(MOD(A1:C1,2)) ODD
Comments
1.
Comment by CARBOB - April 13, 2010, 3:31 pmSteve, I get an error message for this one =COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))
2.
Comment by CARBOB - April 14, 2010, 6:22 amSteve, I was wrong, it works! Must have had the range wrong.
You must be a Lottery Post member to post comments to a Blog.
Register for a FREE membership, or if you're already a member please Log In.
