Spreadsheet: 787598d1657890586-producing-a-sum-summary-table-help-
Sheet: Sheet1

 | ORIGINAL [NAME] MATRIX WITH 33-ZONE SYSTEM
 |  | 33003 | 33008 | 33311 | 35202 | 35203 | 35205 | 35300 | 35303 | 35305 | 35400 | 35403 | 35406 | 35507 | 91001 | 91002 | 91003 | 91004 | 91005 | 91006 | 91007 | 91008 | 91009 | 91010 | 91011 | 91012 | 91013 | 91014 | 91015 | 91016 | 91017 | 91018 | 91019
 | 33003
 | 33008
 | 33311
 | 35202
 | 35203
 | 35205
 | 35300
 | 35303
 | 35305
 | 35400
 | 35403
 | 35406
 | 35507
 | 91001
 | 91002
 | 91003
 | 91004
 | 91005
 | 91006
 | 91007
 | 91008
 | 91009
 | 91010
 | 91011
 | 91012
 | 91013
 | 91014
 | 91015
 | 91016
 | 91017
 | 91018
 | 91019
 | NEW DEMAND MATRIX WITH 24-ZONE SYSTEM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUPING OF ZONES
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  | New Zone | Old Zones
 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 91001 | 91002
 | 2 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 33008 | 91003
 | 3 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 91019
 | 4 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 91018
 | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 91017
 | 6 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 33003
 | 7 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 33311 | 91016
 | 9 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 35205 | 91004 | 91005
 | 11 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 91015
 | 12 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 35202 | 35300 | 91006
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 91014
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 15 | 91007
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 16 | 35403 | 91008 | 91013
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 20 | 91009
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 21 | 91010
 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 22
 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 23
 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 24 | 35507 | 91011