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.
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
– The number is required, the number to find the reminder.
– The divisor is required, which is the divider.