Excel Formula - Count Number Even & Odd in Cell Range /blogentry/39734 winsumloosesum's Blog: Excel Formula - Count Number Even & Odd in Cell Range en-us Lottery Post RSS Generator Comment #2 /blogentry/39734#c47688 /blogentry/39734#c47688 Wed, 14 Apr 2010 10:22:28 GMT CARBOB Steve, I was wrong, it works! Must have had the range wrong.

]]> CARBOB Comment #1 /blogentry/39734#c47674 /blogentry/39734#c47674 Tue, 13 Apr 2010 19:31:41 GMT CARBOB Steve, I get an error message for this one =COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))

]]> CARBOB Original Blog Entry: Excel Formula - Count Number Even & Odd in Cell Range /blogentry/39734 /blogentry/39734 Tue, 13 Apr 2010 17:10:19 GMT winsumloosesum 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

]]> Blog Entry winsumloosesum https://www.lotterypost.com/blogentry/39734