USA Mega

Lottery Places

The time is now 11:47 pm

You last visited
May 10, 2024, 11:17 pm

All times shown are
Eastern Time (GMT-5:00)

Home › Blogs › winsumloosesum's Blog › Excel Formula - Count Number Even & Odd in Cell Range

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

Avatar CARBOB -
#1
Steve, I get an error message for this one =COUNT(A1:C1)-SUMPRODUCT(MOD(A1:C1,2))
Avatar CARBOB -
#2
Steve, I was wrong, it works! Must have had the range wrong.

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register

Guest