COUNT NUMBER EVEN ODD IN CELL RANGE

SUBMITTED BY: Guest

DATE: March 12, 2014, 2:46 p.m.

FORMAT: Text only

SIZE: 491 Bytes

Raw Download

HITS: 1899

Report

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