How to Count Even Numbers

When you work with a worksheet with many different numbers, you may wonder how many of them are odd numbers, and how many of them are even numbers.

Even numbers are those that are divisible by 2, while odd numbers are those numbers that are not divisible by 2. The MOD function returns the remainder after a number is divided by the divisor.

Example: You are working with a dataset with the product in column A, the date in column B, and the amount in column C.

Formula: To count the number of cells that are even numbers

=SUMPRODUCT(--(MOD(C2:C12,2)=0))

(MOD(C2:C12,2)=0): To check whether a number is divisible by 2. If the remainder is equal to 0, that is an even number and the result returns true, otherwise, it returns false;

The double hyphen (--) is to convert true into 1, and false into 0;

The SUMPRODUCT function returns the sum of the products of the new array.

The result returns 5, and there are five even numbers in column C (in light red).

Notes: The MOD Function

Formula:

=MOD(number, divisor)

Explanations:

– The number is required, the number to find the reminder.
– The divisor is required, which is the divider.

Leave a Reply