Spreadsheet: 390945d1429808116-index-match-function-using-a-table-and-named-ranges-biv2
Sheet: Sheet7

Sum of Paid Registrations | Column Labels
Row Labels | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-15 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-15 00:00:00 | 2006-08-15 00:00:00 | 2006-11-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-07-15 00:00:00 | 2007-08-15 00:00:00 | 2007-11-30 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-15 00:00:00 | 2010-08-15 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-15 00:00:00 | 2011-08-15 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-15 00:00:00 | 2012-08-15 00:00:00 | 2012-12-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-15 00:00:00 | 2013-08-15 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-07-15 00:00:00 | 2014-08-30 00:00:00 | 2014-11-30 00:00:00 | 2014-12-31 00:00:00 | 2015-08-30 00:00:00 | Grand Total
(blank) | 44 | 125 | 100 | 92 | 44 | 123 | 134 | 123 | 188 | 68 | 135 | 150 | 125 | 142 | 72 | 149 | 190 | 138 | 122 | 69 | 132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145 | 2610
Collegiate Showcase | 44 |  |  |  | 44 |  |  |  |  | 68 |  |  |  |  | 72 |  |  |  |  | 69 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297
Labor Day |  |  |  | 92 |  |  |  | 123 |  |  |  |  | 125 |  |  |  |  | 138 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 478
Memorial Cup |  | 125 |  |  |  | 123 |  |  |  |  | 135 |  |  |  |  | 149 |  |  |  |  | 132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 664
Spring Classic |  |  | 100 |  |  |  | 134 |  |  |  |  | 150 |  |  |  |  | 190 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 574
Xtreme Cup |  |  |  |  |  |  |  |  | 188 |  |  |  |  | 142 |  |  |  |  | 122 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145 | 597
195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 218 |  |  |  |  |  |  | 218
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173 |  |  |  |  |  |  | 173
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 45
350 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
Xtreme Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
360 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 |  |  |  | 135 |  |  |  | 126 |  |  |  |  |  |  |  | 336
Xtreme Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 |  |  |  | 135 |  |  |  | 126 |  |  |  |  |  |  |  | 336
370 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145 |  |  |  | 145
Xtreme Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145 |  |  |  | 145
400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105
Xtreme Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105
415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  | 32 |  |  |  |  |  |  |  |  |  | 74
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  | 32 |  |  |  |  |  |  |  |  |  | 74
425 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  | 35
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  | 35
450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  | 31 |  |  |  |  |  |  |  |  | 56
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  | 31 |  |  |  |  |  |  |  |  | 56
460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  | 31
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  | 31
495 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157 |  |  | 76 |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 24 |  |  |  |  |  |  |  |  | 288
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157
Memorial Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 24 |  |  |  |  |  |  |  |  | 55
505 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 34
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 34
515 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 177 |  |  |  |  | 170 |  |  | 93 |  |  |  |  | 83 |  |  |  | 80 |  |  |  |  |  |  |  |  |  | 603
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170
Memorial Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 177 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 177
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 |  |  |  | 80 |  |  |  |  |  |  |  |  |  | 163
525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 |  |  |  |  |  |  |  |  | 85 |  |  |  |  |  | 176
Memorial Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
Spring Classic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 |  |  |  |  |  | 85
550 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141 |  |  |  | 115 |  |  |  | 123 |  |  |  |  |  |  |  |  | 379
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141 |  |  |  | 115 |  |  |  | 123 |  |  |  |  |  |  |  |  | 379
560 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116 |  |  |  |  | 116
Labor Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116 |  |  |  |  | 116
595 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 |  |  |  | 85 |  |  |  |  |  |  |  |  | 217
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 |  |  |  | 85 |  |  |  |  |  |  |  |  | 217
605 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 |  |  |  |  | 94
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 |  |  |  |  | 94
650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 20
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  | 20
660 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16
700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225
Sounders Cup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225
800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
825 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
850 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 |  |  |  | 82 |  |  |  | 64 |  |  |  |  |  |  | 220
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 |  |  |  | 82 |  |  |  | 64 |  |  |  |  |  |  | 220
860 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68 |  |  | 68
Collegiate Showcase |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68 |  |  | 68
Grand Total | 44 | 125 | 100 | 92 | 44 | 123 | 134 | 123 | 188 | 68 | 135 | 150 | 125 | 142 | 72 | 149 | 190 | 138 | 122 | 69 | 132 | 69 | 334 | 105 | 80 | 76 | 34 | 290 | 70 | 82 | 93 | 62 | 246 | 75 | 165 | 125 | 272 | 135 | 113 | 112 | 263 | 126 | 302 | 120 | 275 | 145 | 68 | 16 | 145 | 6463