How to Count Odd 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.

Odd numbers are those numbers that are not divisible by 2, while even numbers are those that are 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 odd numbers


(MOD(C2:C12,2)=1): To check whether a number is divisible by 2. If the remainder is equal to 1, that is an odd 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 6, and there are six odd numbers in column C (in light green).

Notes: The MOD Function


=MOD(number, divisor)


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

Leave a Reply