View Single Post
 
Old 01-14-2016, 07:02 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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.
Reply With Quote