Spreadsheet: 869011d1715696216-index-and-match-totals-not-adding-up-test_01gk
Sheet: Sheet2

HOUSE TYPE |  | PRICE BAND1
277 Drake | Price Group 1 | 1956 |  |  |  | Price Group 1
2BBLTH | Price Group 1 | 2048 |  |  |  | Price Group 2 |  |  |  |  | Type |  | 403 Exclusive |  | Price Group | Price Group 3
2BCB | Price Group 1 | 2097 |  |  |  | 20mm Mirage
2BCBA | Price Group 1 | 1956 |  |  |  | Price Group 3 |  |  |  |  | Type
2BCBA | Price Group 1 | 2003 |  |  |  | Price Group 4 |  |  |  |  | CHOICE #1
2BCBSP Special | Price Group 1 | 1956 |  |  |  |  |  |  |  |  | CHOICE #1234
301 HT | Price Group 1 | 2164 |  |  |  | 277 Drake |  |  |  |  | N |  |  |  |  | Total
303 Special | Price Group 1 | 1956 |  |  |  | 2BBLTH |  |  |  |  | N
304 Tow | Price Group 1 | 2048 |  |  |  | 2BCB |  |  |  |  | N
341 Special | Price Group 1 | 2097 |  |  |  | 2BCBA |  |  |  |  | N
342 Exclusive | Price Group 1 | 2164 |  |  |  | 2BCBA |  |  |  |  | N
342 Special | Price Group 1 | 2097 |  |  |  | 2BCBSP Special |  |  |  |  | N
350 HT | Price Group 1 | 2003 |  |  |  | 301 HT |  |  |  |  | N
353 Special | Price Group 1 | 2003 |  |  |  | 303 Special
360 Exlcusive | Price Group 1 | 2003 |  |  |  | 304 Tow
361 Exclusive | Price Group 1 | 2003 |  |  |  | 341 Special
363 Exclusive | Price Group 1 | 2003 |  |  |  | 342 Exclusive
364 Exclusive | Price Group 1 | 2003 |  |  |  | 342 Special
368 Exclusive | Price Group 1 | 2003 |  |  |  | 350 HT
369 Exclusive | Price Group 1 | 2097 |  |  |  | 353 Special
372 Byron | Price Group 1 | 2003 |  |  |  | 360 Exlcusive
380 Exclusive | Price Group 1 | 2048 |  |  |  | 361 Exclusive
3B5P Sorley | Price Group 1 | 2003 |  |  |  | 363 Exclusive
3BH (305) | Price Group 1 | 2003 |  |  |  | 364 Exclusive
403 Exclusive | Price Group 1 | 2003 |  |  |  | 368 Exclusive
404 HT | Price Group 1 | 2164 |  |  |  | 369 Exclusive
405 V1 | Price Group 1 | 2048 |  |  |  | 372 Byron
406 Exclusive | Price Group 1 | 2048 |  |  |  | 380 Exclusive
407 Exclusive | Price Group 1 | 2097 |  |  |  | 3B5P Sorley
408 Exclusive | Price Group 1 | 2048 |  |  |  | 3BH (305)
410 Exclusive | Price Group 1 | 2097 |  |  |  | 403 Exclusive
411 Special | Price Group 1 | 2164 |  |  |  | 404 HT
412 Exclusive | Price Group 1 | 2097 |  |  |  | 405 V1
413 Exclusive | Price Group 1 | 2164 |  |  |  | 406 Exclusive
414 Exlusive | Price Group 1 | 2212 |  |  |  | 407 Exclusive
417 Exclusive | Price Group 1 | 2164 |  |  |  | 408 Exclusive
418 Special | Price Group 1 | 2212 |  |  |  | 410 Exclusive
418 Special | Price Group 1 | 2212 |  |  |  | 411 Special
419 Exclusive | Price Group 1 | 2164 |  |  |  | 412 Exclusive
420 Exclusive | Price Group 1 | 2048 |  |  |  | 413 Exclusive
277 Drake | Price Group 2 | 2120 |  |  |  | 414 Exlusive
2BBLTH | Price Group 2 | 2220 |  |  |  | 417 Exclusive
2BCB | Price Group 2 | 2272 |  |  |  | 418 Special
2BCBA | Price Group 2 | 2120 |  |  |  | 418 Special
2BCBA | Price Group 2 | 2170 |  |  |  | 419 Exclusive
2BCBSP Special | Price Group 2 | 2120 |  |  |  | 420 Exclusive
301 HT | Price Group 2 | 2345
303 Special | Price Group 2 | 2120
304 Tow | Price Group 2 | 2220
341 Special | Price Group 2 | 2272
342 Exclusive | Price Group 2 | 2345
342 Special | Price Group 2 | 2272
350 HT | Price Group 2 | 2170
353 Special | Price Group 2 | 2170
360 Exlcusive | Price Group 2 | 2170
361 Exclusive | Price Group 2 | 2170
363 Exclusive | Price Group 2 | 2170
364 Exclusive | Price Group 2 | 2170
368 Exclusive | Price Group 2 | 2170
369 Exclusive | Price Group 2 | 2272
372 Byron | Price Group 2 | 2170
380 Exclusive | Price Group 2 | 2220
3B5P Sorley | Price Group 2 | 2170
3BH (305) | Price Group 2 | 2170
403 Exclusive | Price Group 2 | 2170
404 HT | Price Group 2 | 2345
405 V1 | Price Group 2 | 2220
406 Exclusive | Price Group 2 | 2220
407 Exclusive | Price Group 2 | 2272
408 Exclusive | Price Group 2 | 2220
410 Exclusive | Price Group 2 | 2272
411 Special | Price Group 2 | 2345
412 Exclusive | Price Group 2 | 2272
413 Exclusive | Price Group 2 | 2345
414 Exlusive | Price Group 2 | 2396
417 Exclusive | Price Group 2 | 2345
418 Special | Price Group 2 | 2396
418 Special | Price Group 2 | 2396
419 Exclusive | Price Group 2 | 2345
420 Exclusive | Price Group 2 | 2220
277 Drake | 20mm Mirage | 2298
2BBLTH | 20mm Mirage | 2405
2BCB | 20mm Mirage | 2462
2BCBA | 20mm Mirage | 2298
2BCBA | 20mm Mirage | 2351
2BCBSP Special | 20mm Mirage | 2298
301 HT | 20mm Mirage | 2539
303 Special | 20mm Mirage | 2298
304 Tow | 20mm Mirage | 2405
341 Special | 20mm Mirage | 2462
342 Exclusive | 20mm Mirage | 2539
342 Special | 20mm Mirage | 2462
350 HT | 20mm Mirage | 2351
353 Special | 20mm Mirage | 2351
360 Exlcusive | 20mm Mirage | 2351
361 Exclusive | 20mm Mirage | 2351
363 Exclusive | 20mm Mirage | 2351
364 Exclusive | 20mm Mirage | 2351
368 Exclusive | 20mm Mirage | 2351
369 Exclusive | 20mm Mirage | 2462
372 Byron | 20mm Mirage | 2351
380 Exclusive | 20mm Mirage | 2405
3B5P Sorley | 20mm Mirage | 2351
3BH (305) | 20mm Mirage | 2351
403 Exclusive | 20mm Mirage | 2351
404 HT | 20mm Mirage | 2539
405 V1 | 20mm Mirage | 2405
406 Exclusive | 20mm Mirage | 2405
407 Exclusive | 20mm Mirage | 2462
408 Exclusive | 20mm Mirage | 2405
410 Exclusive | 20mm Mirage | 2462
411 Special | 20mm Mirage | 2539
412 Exclusive | 20mm Mirage | 2462
413 Exclusive | 20mm Mirage | 2539
414 Exlusive | 20mm Mirage | 2594
417 Exclusive | 20mm Mirage | 2539
418 Special | 20mm Mirage | 2594
418 Special | 20mm Mirage | 2594
419 Exclusive | 20mm Mirage | 2539
420 Exclusive | 20mm Mirage | 2405
277 Drake | Price Group 3 | 2298
2BBLTH | Price Group 3 | 2405
2BCB | Price Group 3 | 2462
2BCBA | Price Group 3 | 2298
2BCBA | Price Group 3 | 2351
2BCBSP Special | Price Group 3 | 2298
301 HT | Price Group 3 | 2539
303 Special | Price Group 3 | 2298
304 Tow | Price Group 3 | 2405
341 Special | Price Group 3 | 2462
342 Exclusive | Price Group 3 | 2539
342 Special | Price Group 3 | 2462
350 HT | Price Group 3 | 2351
353 Special | Price Group 3 | 2351
360 Exlcusive | Price Group 3 | 2351
361 Exclusive | Price Group 3 | 2351
363 Exclusive | Price Group 3 | 2351
364 Exclusive | Price Group 3 | 2351
368 Exclusive | Price Group 3 | 2351
369 Exclusive | Price Group 3 | 2462
372 Byron | Price Group 3 | 2351
380 Exclusive | Price Group 3 | 2405
3B5P Sorley | Price Group 3 | 2351
3BH (305) | Price Group 3 | 2351
403 Exclusive | Price Group 3 | 2351
404 HT | Price Group 3 | 2539
405 V1 | Price Group 3 | 2405
406 Exclusive | Price Group 3 | 2405
407 Exclusive | Price Group 3 | 2462
408 Exclusive | Price Group 3 | 2405
410 Exclusive | Price Group 3 | 2462
411 Special | Price Group 3 | 2539
412 Exclusive | Price Group 3 | 2462
413 Exclusive | Price Group 3 | 2539
414 Exlusive | Price Group 3 | 2594
417 Exclusive | Price Group 3 | 2539
418 Special | Price Group 3 | 2594
418 Special | Price Group 3 | 2594
419 Exclusive | Price Group 3 | 2539
420 Exclusive | Price Group 3 | 2405
277 Drake | Price Group 4 | 2488
2BBLTH | Price Group 4 | 2605
2BCB | Price Group 4 | 2665
2BCBA | Price Group 4 | 2488
2BCBA | Price Group 4 | 2547
2BCBSP Special | Price Group 4 | 2488
301 HT | Price Group 4 | 2750
303 Special | Price Group 4 | 2488
304 Tow | Price Group 4 | 2605
341 Special | Price Group 4 | 2665
342 Exclusive | Price Group 4 | 2750
342 Special | Price Group 4 | 2665
350 HT | Price Group 4 | 2547
353 Special | Price Group 4 | 2547
360 Exlcusive | Price Group 4 | 2547
361 Exclusive | Price Group 4 | 2547
363 Exclusive | Price Group 4 | 2547
364 Exclusive | Price Group 4 | 2547
368 Exclusive | Price Group 4 | 2547
369 Exclusive | Price Group 4 | 2665
372 Byron | Price Group 4 | 2547
380 Exclusive | Price Group 4 | 2605
3B5P Sorley | Price Group 4 | 2547
3BH (305) | Price Group 4 | 2547
403 Exclusive | Price Group 4 | 2547
404 HT | Price Group 4 | 2750
405 V1 | Price Group 4 | 2605
406 Exclusive | Price Group 4 | 2605
407 Exclusive | Price Group 4 | 2665
408 Exclusive | Price Group 4 | 2605
410 Exclusive | Price Group 4 | 2665
411 Special | Price Group 4 | 2750
412 Exclusive | Price Group 4 | 2665
413 Exclusive | Price Group 4 | 2750
414 Exlusive | Price Group 4 | 2809
417 Exclusive | Price Group 4 | 2750
418 Special | Price Group 4 | 2809
418 Special | Price Group 4 | 2809
419 Exclusive | Price Group 4 | 2750
420 Exclusive | Price Group 4 | 2605
OPTIONAL [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRICE BAND3 |  |  |  |  |  |  | PRICE BAND 4
CHOICE #1 | Price Group 1 | 265
CHOICE #12 | Price Group 1 | 476
CHOICE #123 | Price Group 1 | 105
CHOICE #1234 | Price Group 1 | 59
CHOICE #12345 | Price Group 1 | 128
CHOICE #123456 | Price Group 1 | 70
CHOICE #1234567 | Price Group 1 | 158
CHOICE #12345678 | Price Group 1 | 87
CHOICE #123456789 | Price Group 1 | 64
NO VALUE | Price Group 1 | 0
CHOICE #1 | Price Group 2 | 287
CHOICE #12 | Price Group 2 | 498
CHOICE #123 | Price Group 2 | 112
CHOICE #1234 | Price Group 2 | 63
CHOICE #12345 | Price Group 2 | 138
CHOICE #123456 | Price Group 2 | 76
CHOICE #1234567 | Price Group 2 | 175
CHOICE #12345678 | Price Group 2 | 95
CHOICE #123456789 | Price Group 2 | 64
NO VALUE | Price Group 2 | 0
CHOICE #1 | 20mm Mirage | 310
CHOICE #12 | 20mm Mirage | 581
CHOICE #123 | 20mm Mirage | 122
CHOICE #1234 | 20mm Mirage | 68
CHOICE #12345 | 20mm Mirage | 149
CHOICE #123456 | 20mm Mirage | 82
CHOICE #1234567 | 20mm Mirage | 191
CHOICE #12345678 | 20mm Mirage | 104
CHOICE #123456789 | 20mm Mirage | 64
NO VALUE | 20mm Mirage | 0
CHOICE #1 | Price Group 3 | 310
CHOICE #12 | Price Group 3 | 581
CHOICE #123 | Price Group 3 | 122
CHOICE #1234 | Price Group 3 | 68
CHOICE #12345 | Price Group 3 | 149
CHOICE #123456 | Price Group 3 | 82
CHOICE #1234567 | Price Group 3 | 191
CHOICE #12345678 | Price Group 3 | 104
CHOICE #123456789 | Price Group 3 | 64
NO VALUE | Price Group 3 | 0
CHOICE #1 | Price Group 4 | 334
CHOICE #12 | Price Group 4 | 772
CHOICE #123 | Price Group 4 | 132
CHOICE #1234 | Price Group 4 | 74
CHOICE #12345 | Price Group 4 | 159
CHOICE #123456 | Price Group 4 | 88
CHOICE #1234567 | Price Group 4 | 207
CHOICE #12345678 | Price Group 4 | 112
CHOICE #123456789 | Price Group 4 | 64
NO VALUE | Price Group 4 | 0