MOD(Range,2)=1 will create an array of Boolean values where TRUE will mean the number is odd and FALSE will mean the number is not odd. We then convert these TRUE and FALSE values to 1 and 0 values by multiplying the array by 1. This will give us the count of the number of odd numbers in the range. In our example MOD({1.36;-2;2;9;10;7;1.33;8},2)=1 will result in the following Boolean array. When we multiply this by 1 we get {0;0;0;1;0;1;0;0}. Then SUM({0;0;0;1;0;1;0;0}) results in 2 which is the count of odd numbers in our range of values.

How To Count All Odd Numbers In A Range - 7