You want to figure out odd or even numbers and count them in excel. This article will help you know odd and even number in excel by using MOD function
MOD function Returns the remainder after the number is divided by a divisor. The result has the same sign as divisor.
- Number Required. The number for which you want to find the remainder.
- Divisor Required. The number by which you want to divide number.
How to count cells that contain odd numbers?
The first we need to know where cell have contained odd number by using MOD(). In this case, the divisor is 2, so MOD will return a remainder of 1 for any odd integer, and a remainder of zero for even numbers. Then use SUMPRODUCT function to count odd numbers.
range represents a range of cells that contain numbers
The result is: 5