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 multiply this Boolean array by the Range to get an array where each value is either an odd value from the Range or a 0. This is because NTRUE equals N and NFALSE equals 0 for any number N. 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 Range we get {0;0;0;9;0;7;0;0}. Then SUM({0;0;0;9;0;7;0;0}) results in 16 which is the sum of all odd numbers in our range of values.

How To Sum All Odd Numbers In A Range - 37