MOD(Range,2)=0 will create an array of Boolean values where TRUE will mean the number is even and FALSE will mean the number is not even. We then multiply this Boolean array by the Range to get an array where each value is either an even 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)=0 will result in the following Boolean array. When we multiply this by Range we get {0;-2;2;0;10;0;0;8}. Then SUM({0;-2;2;0;10;0;0;8}) results in 18 which is the sum of all even numbers in our range of values.

How To Sum All Even Numbers In A Range - 49