Spreadsheet: 145321d1331531508-sumproduct-issue-help-sample_sumprod
Sheet: Summary

 |  | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Won |  |  |  | Won |  |  |  | Won |  |  |  | Won
 |  |  |  |  |  |  | Won | Won | Won |  | Lost | Lost | Lost |  | Pending | Pending | Pending |  | Type 1: Inbound (new customer) | Type 1: Inbound (new customer) | Type 1: Inbound (new customer) | Type 1: Inbound (new customer) | Type 2: Inbound (existing) | Type 2: Inbound (existing) | Type 2: Inbound (existing) | Type 2: Inbound (existing) | Type 3: Outbound (new customer) | Type 3: Outbound (new customer) | Type 3: Outbound (new customer) | Type 3: Outbound (new customer) | Type 4: Outbound (existing) | Type 4: Outbound (existing) | Type 4: Outbound (existing) | Type 4: Outbound (existing)
 |  | Canada East | Prospects Quoted |  |  |  | Won |  |  |  | Lost |  |  |  | Pending |  |  |  | Opportunity - Type 1: Inbound (new customer) |  |  |  | Opportunity - Type 2:  Inbound (existing) |  |  |  | Opportunity - Type 3: Outbound (new customer) |  |  |  | Opportunity - Type 4: Outbound (existing)
 |  | District | # Total Oppor. | # of Proposals given | $ Total Oppor. |  | # Total oppor. Won | $ Total oppor. Won | Closing % |  | # Total oppor. Lost | $ Total oppor. Lost | Closing % |  | # Total oppor. Pending | $ Total oppor. Pending | Closing % |  | # of Type 1 deals quoted | $ of Type 1 quoted | # of Type 1 quoted - Won | Closing % | # of Type 2 deals quoted | $ of Type 2 quoted | # of Type 2 quoted - Won | Closing % | # of Type 3 deals quoted | $ of Type 3 quoted | # of Type 3 quoted - Won | Closing % | # of Type 4 deals quoted | $ of Type 4 quoted | # of Type 4 quoted - Won | Closing %
 |  | Vancouver-Kelowna
 |  | Saskatoon
 |  | Calgary-Edmonton
 |  | Cambridge-London
 |  | Halifax-Moncton
 |  | Montreal-Quebec City
 |  | Ottawa
 |  | Toronto
 |  | Branch
 |  | Halifax | 131 | 131 | 34560.25 |  | 107 | 32348.25 | 0.816793893129771 |  | 3 | 235 | 0.02290076335877863 |  | 14 | 1755 | 0.1068702290076336 |  | 35 | 7349.5 | 23 | 0.6571428571428571 | 82 | 26025.75 | 79 | 0.9634146341463414 | 10 | 935 | 5 | 0.5 | 4 | 250 | 0 | 0
 |  | [NAME] | 131 | 131 | 34560.25 |  | 107 | 32348.25 | 0.816793893129771 |  | 3 | 235 | 0.02290076335877863 |  | 14 | 1755 | 0.1068702290076336 |  | 35 | 7349.5 | 23 | 0.6571428571428571 | 82 | 26025.75 | 79 | 0.9634146341463414 | 10 | 935 | 5 | 0.5 | 4 | 250 | 0 | 0
 |  | Montreal | 131 | 131 | 34560.25 |  | 107 | 32348.25 | 0.816793893129771 |  | 3 | 235 | 0.02290076335877863 |  | 14 | 1755 | 0.1068702290076336 |  | 35 | 7349.5 | 23 | 0.6571428571428571 | 82 | 26025.75 | 79 | 0.9634146341463414 | 10 | 935 | 5 | 0.5 | 4 | 250 | 0 | 0
 |  | Quebec City | 17 | 17 | 767 |  | 0 | 0 | 0 |  | 3 | 235 | 0.1764705882352941 |  | 7 | 310 | 0.4117647058823529 |  | 7 | 287 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 230 | 0 | 0 | 4 | 250 | 0 | 0
 |  | Ottawa | 17 | 17 | 767 |  | 0 | 0 | 0 |  | 3 | 235 | 0.1764705882352941 |  | 7 | 310 | 0.4117647058823529 |  | 7 | 287 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 230 | 0 | 0 | 4 | 250 | 0 | 0
 |  | Winnipeg | 17 | 17 | 767 |  | 0 | 0 | 0 |  | 3 | 235 | 0.1764705882352941 |  | 7 | 310 | 0.4117647058823529 |  | 7 | 287 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 230 | 0 | 0 | 4 | 250 | 0 | 0
 |  | Toronto | 17 | 17 | 767 |  | 0 | 0 | 0 |  | 3 | 235 | 0.1764705882352941 |  | 7 | 310 | 0.4117647058823529 |  | 7 | 287 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 230 | 0 | 0 | 4 | 250 | 0 | 0
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  |  |  | 131
 |  | x