Spreadsheet: 96388d1295807133-condition-based-sumproduct-sumproduct
Sheet: Output

 |  |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  | Key1 | Month | Month Text | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 6 | 21 | 113 | 30 | 170 |  |  |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 1 | 27 | 99 | 21 | 148 |  |  |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 1 | 3 | 22 | 87 | 17 | 130 |  |  |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  |  |  |  |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 2 | 5 | 29 | 69 | 17 | 122 |  |  |  |  |  |  |  | 2009-09-01 00:00:00
 |  |  |  |  |  |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 1 | 5 | 27 | 95 | 19 | 147 |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 1 | 4 | 30 | 120 | 7 | 162 |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 1 | 4 | 29 | 122 | 9 | 165 |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 3 | 5 | 28 | 122 | 11 | 169 |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 2 | 5 | 22 | 144 | 13 | 186 |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 1 | 4 | 38 | 109 | 19 | 171 |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 1 | 5 | 24 | 121 | 19 | 170 |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  |  |  |  |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 2 | 6 | 32 | 85 | 12 | 137 |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 15 | 53 | 329 | 1286 | 194 | 1877 |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  | Key1 | Month | Month Text | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
 |  |  |  |  |  |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-02-01 00:00:00
 |  |  |  |  |  |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-03-01 00:00:00
 |  |  |  |  |  |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 |  |  |  |  |  |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  |  |  |  |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  |  |  |  |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Key1 | Month | Month Text | Canada | Exchange | Management | ZNA | All
 |  |  |  |  |  |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 0 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 1 | 3 | 6 | 5
 |  |  |  |  |  |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 0 | 1 | 2 | 1
 |  |  |  |  |  |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 1 | 5 | 4 | 3
 |  |  |  |  |  |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 0 | 1 | 1 | 6
 |  |  |  |  |  |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 0 | 2 | 5 | 3
 |  |  |  |  |  |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 0 | 0 | 2 | 4
 |  |  |  |  |  |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 1 | 0 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  | 3 | 13 | 24 | 25
 |  |  |  |  |  |  |  | Key1 | Month | Month Text | Canada | Exchange | Management | ZNA | All
 |  |  |  |  |  |  |  | 12 | 2010-01-01 00:00:00 | Jan-10
 |  |  |  |  |  |  |  | 11 | 2010-02-01 00:00:00 | Feb-10
 |  |  |  |  |  |  |  | 10 | 2010-03-01 00:00:00 | Mar-10
 |  |  |  |  |  |  |  | 9 | 2010-04-01 00:00:00 | Apr-10
 |  |  |  |  |  |  |  | 8 | 2010-05-01 00:00:00 | May-10
 |  |  |  |  |  |  |  | 7 | 2010-06-01 00:00:00 | Jun-10
 |  |  |  |  |  |  |  | 6 | 2010-07-01 00:00:00 | Jul-10
 |  |  |  |  |  |  |  | 5 | 2010-08-01 00:00:00 | Aug-10
 |  |  |  |  |  |  |  | 4 | 2010-09-01 00:00:00 | Sep-10
 |  |  |  |  |  |  |  | 3 | 2010-10-01 00:00:00 | Oct-10
 |  |  |  |  |  |  |  | 2 | 2010-11-01 00:00:00 | Nov-10
 |  |  |  |  |  |  |  | 1 | 2010-12-01 00:00:00 | Dec-10