The last section creates two arrays of TRUE and FALSE values. SUMPRODUCT ignores these values, so to make them count the two arrays are multiplied together. For the multiplication, TRUE is coerced to 1 and FALSE to 0, so you end up with an array of 0 and 1 which is then multiplied by the actual data values before they are then summed up.
|