|
|
#6
01-14-2016, 07:02 AM
|
||||
|
||||
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.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Pull the data from different closed workbooks paste into master vba
|
manilara | Excel Programming | 2 | 11-19-2015 08:41 PM |
|
Vlookup multiple workbooks
|
c123456 | Excel | 3 | 03-13-2015 12:59 PM |
| Office 2008 workbooks into Office 2011 workbooks | nfotx | Excel | 0 | 12-07-2014 04:22 PM |
|
Help with SUMIFS
|
LeFoah | Excel | 2 | 10-20-2013 09:22 AM |
| Link multiple excel workbooks to publisher | bandcsaravia | Publisher | 0 | 10-24-2011 09:14 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode