Welcome Guest
( Log In | Register )
The time is now 10:21 am
You last visited January 17, 2017, 9:54 am
All times shown are
Eastern Time (GMT-5:00)

Excel Formula - Count Number Even & Odd in Cell Range

Published:

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

Entry #147

Comments

1.
CARBOBComment by CARBOB - April 13, 2010, 3:31 pm
Steve, I get an error message for this one =COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))
2.
CARBOBComment by CARBOB - April 14, 2010, 6:22 am
Steve, 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.