Spreadsheet: 869006d1715695146-index-and-match-totals-not-adding-up-test_01
Sheet: Sheet2

HOUSE TYPE |  | PRICE BAND1
277 Drake | Price Group 1 | £1,956.00 |  |  |  | Price Group 1
2BBLTH | Price Group 1 | £2,048.00 |  |  |  | Price Group 2 |  |  |  |  | Type |  | 403 Exclusive |  | Price Group | Price Group 3
2BCB | Price Group 1 | £2,097.00 |  |  |  | 20mm Mirage
2BCBA | Price Group 1 | £1,956.00 |  |  |  | Price Group 3 |  |  |  |  | Type
2BCBA | Price Group 1 | £2,003.00 |  |  |  | Price Group 4 |  |  |  |  | CHOICE #1
2BCBSP Special | Price Group 1 | £1,956.00 |  |  |  |  |  |  |  |  | CHOICE #1234
301 HT | Price Group 1 | £2,164.00 |  |  |  | 277 Drake |  |  |  |  | N |  |  |  |  | Total
303 Special | Price Group 1 | £1,956.00 |  |  |  | 2BBLTH |  |  |  |  | N
304 Tow | Price Group 1 | £2,048.00 |  |  |  | 2BCB |  |  |  |  | N
341 Special | Price Group 1 | £2,097.00 |  |  |  | 2BCBA |  |  |  |  | N
342 Exclusive | Price Group 1 | £2,164.00 |  |  |  | 2BCBA |  |  |  |  | N
342 Special | Price Group 1 | £2,097.00 |  |  |  | 2BCBSP Special |  |  |  |  | N
350 HT | Price Group 1 | £2,003.00 |  |  |  | 301 HT |  |  |  |  | N
353 Special | Price Group 1 | £2,003.00 |  |  |  | 303 Special
360 Exlcusive | Price Group 1 | £2,003.00 |  |  |  | 304 Tow
361 Exclusive | Price Group 1 | £2,003.00 |  |  |  | 341 Special
363 Exclusive | Price Group 1 | £2,003.00 |  |  |  | 342 Exclusive
364 Exclusive | Price Group 1 | £2,003.00 |  |  |  | 342 Special
368 Exclusive | Price Group 1 | £2,003.00 |  |  |  | 350 HT
369 Exclusive | Price Group 1 | £2,097.00 |  |  |  | 353 Special
372 Byron | Price Group 1 | £2,003.00 |  |  |  | 360 Exlcusive
380 Exclusive | Price Group 1 | £2,048.00 |  |  |  | 361 Exclusive
3B5P Sorley | Price Group 1 | £2,003.00 |  |  |  | 363 Exclusive
3BH (305) | Price Group 1 | £2,003.00 |  |  |  | 364 Exclusive
403 Exclusive | Price Group 1 | £2,003.00 |  |  |  | 368 Exclusive
404 HT | Price Group 1 | £2,164.00 |  |  |  | 369 Exclusive
405 V1 | Price Group 1 | £2,048.00 |  |  |  | 372 Byron
406 Exclusive | Price Group 1 | £2,048.00 |  |  |  | 380 Exclusive
407 Exclusive | Price Group 1 | £2,097.00 |  |  |  | 3B5P Sorley
408 Exclusive | Price Group 1 | £2,048.00 |  |  |  | 3BH (305)
410 Exclusive | Price Group 1 | £2,097.00 |  |  |  | 403 Exclusive
411 Special | Price Group 1 | £2,164.00 |  |  |  | 404 HT
412 Exclusive | Price Group 1 | £2,097.00 |  |  |  | 405 V1
413 Exclusive | Price Group 1 | £2,164.00 |  |  |  | 406 Exclusive
414 Exlusive | Price Group 1 | £2,212.00 |  |  |  | 407 Exclusive
417 Exclusive | Price Group 1 | £2,164.00 |  |  |  | 408 Exclusive
418 Special | Price Group 1 | £2,212.00 |  |  |  | 410 Exclusive
418 Special | Price Group 1 | £2,212.00 |  |  |  | 411 Special
419 Exclusive | Price Group 1 | £2,164.00 |  |  |  | 412 Exclusive
420 Exclusive | Price Group 1 | £2,048.00 |  |  |  | 413 Exclusive
277 Drake | Price Group 2 | £2,120.00 |  |  |  | 414 Exlusive
2BBLTH | Price Group 2 | £2,220.00 |  |  |  | 417 Exclusive
2BCB | Price Group 2 | £2,272.00 |  |  |  | 418 Special
2BCBA | Price Group 2 | £2,120.00 |  |  |  | 418 Special
2BCBA | Price Group 2 | £2,170.00 |  |  |  | 419 Exclusive
2BCBSP Special | Price Group 2 | £2,120.00 |  |  |  | 420 Exclusive
301 HT | Price Group 2 | £2,345.00
303 Special | Price Group 2 | £2,120.00
304 Tow | Price Group 2 | £2,220.00
341 Special | Price Group 2 | £2,272.00
342 Exclusive | Price Group 2 | £2,345.00
342 Special | Price Group 2 | £2,272.00
350 HT | Price Group 2 | £2,170.00
353 Special | Price Group 2 | £2,170.00
360 Exlcusive | Price Group 2 | £2,170.00
361 Exclusive | Price Group 2 | £2,170.00
363 Exclusive | Price Group 2 | £2,170.00
364 Exclusive | Price Group 2 | £2,170.00
368 Exclusive | Price Group 2 | £2,170.00
369 Exclusive | Price Group 2 | £2,272.00
372 Byron | Price Group 2 | £2,170.00
380 Exclusive | Price Group 2 | £2,220.00
3B5P Sorley | Price Group 2 | £2,170.00
3BH (305) | Price Group 2 | £2,170.00
403 Exclusive | Price Group 2 | £2,170.00
404 HT | Price Group 2 | £2,345.00
405 V1 | Price Group 2 | £2,220.00
406 Exclusive | Price Group 2 | £2,220.00
407 Exclusive | Price Group 2 | £2,272.00
408 Exclusive | Price Group 2 | £2,220.00
410 Exclusive | Price Group 2 | £2,272.00
411 Special | Price Group 2 | £2,345.00
412 Exclusive | Price Group 2 | £2,272.00
413 Exclusive | Price Group 2 | £2,345.00
414 Exlusive | Price Group 2 | £2,396.00
417 Exclusive | Price Group 2 | £2,345.00
418 Special | Price Group 2 | £2,396.00
418 Special | Price Group 2 | £2,396.00
419 Exclusive | Price Group 2 | £2,345.00
420 Exclusive | Price Group 2 | £2,220.00
277 Drake | 20mm Mirage | £2,298.00
2BBLTH | 20mm Mirage | £2,405.00
2BCB | 20mm Mirage | £2,462.00
2BCBA | 20mm Mirage | £2,298.00
2BCBA | 20mm Mirage | £2,351.00
2BCBSP Special | 20mm Mirage | £2,298.00
301 HT | 20mm Mirage | £2,539.00
303 Special | 20mm Mirage | £2,298.00
304 Tow | 20mm Mirage | £2,405.00
341 Special | 20mm Mirage | £2,462.00
342 Exclusive | 20mm Mirage | £2,539.00
342 Special | 20mm Mirage | £2,462.00
350 HT | 20mm Mirage | £2,351.00
353 Special | 20mm Mirage | £2,351.00
360 Exlcusive | 20mm Mirage | £2,351.00
361 Exclusive | 20mm Mirage | £2,351.00
363 Exclusive | 20mm Mirage | £2,351.00
364 Exclusive | 20mm Mirage | £2,351.00
368 Exclusive | 20mm Mirage | £2,351.00
369 Exclusive | 20mm Mirage | £2,462.00
372 Byron | 20mm Mirage | £2,351.00
380 Exclusive | 20mm Mirage | £2,405.00
3B5P Sorley | 20mm Mirage | £2,351.00
3BH (305) | 20mm Mirage | £2,351.00
403 Exclusive | 20mm Mirage | £2,351.00
404 HT | 20mm Mirage | £2,539.00
405 V1 | 20mm Mirage | £2,405.00
406 Exclusive | 20mm Mirage | £2,405.00
407 Exclusive | 20mm Mirage | £2,462.00
408 Exclusive | 20mm Mirage | £2,405.00
410 Exclusive | 20mm Mirage | £2,462.00
411 Special | 20mm Mirage | £2,539.00
412 Exclusive | 20mm Mirage | £2,462.00
413 Exclusive | 20mm Mirage | £2,539.00
414 Exlusive | 20mm Mirage | £2,594.00
417 Exclusive | 20mm Mirage | £2,539.00
418 Special | 20mm Mirage | £2,594.00
418 Special | 20mm Mirage | £2,594.00
419 Exclusive | 20mm Mirage | £2,539.00
420 Exclusive | 20mm Mirage | £2,405.00
277 Drake | Price Group 3 | £2,298.00
2BBLTH | Price Group 3 | £2,405.00
2BCB | Price Group 3 | £2,462.00
2BCBA | Price Group 3 | £2,298.00
2BCBA | Price Group 3 | £2,351.00
2BCBSP Special | Price Group 3 | £2,298.00
301 HT | Price Group 3 | £2,539.00
303 Special | Price Group 3 | £2,298.00
304 Tow | Price Group 3 | £2,405.00
341 Special | Price Group 3 | £2,462.00
342 Exclusive | Price Group 3 | £2,539.00
342 Special | Price Group 3 | £2,462.00
350 HT | Price Group 3 | £2,351.00
353 Special | Price Group 3 | £2,351.00
360 Exlcusive | Price Group 3 | £2,351.00
361 Exclusive | Price Group 3 | £2,351.00
363 Exclusive | Price Group 3 | £2,351.00
364 Exclusive | Price Group 3 | £2,351.00
368 Exclusive | Price Group 3 | £2,351.00
369 Exclusive | Price Group 3 | £2,462.00
372 Byron | Price Group 3 | £2,351.00
380 Exclusive | Price Group 3 | £2,405.00
3B5P Sorley | Price Group 3 | £2,351.00
3BH (305) | Price Group 3 | £2,351.00
403 Exclusive | Price Group 3 | £2,351.00
404 HT | Price Group 3 | £2,539.00
405 V1 | Price Group 3 | £2,405.00
406 Exclusive | Price Group 3 | £2,405.00
407 Exclusive | Price Group 3 | £2,462.00
408 Exclusive | Price Group 3 | £2,405.00
410 Exclusive | Price Group 3 | £2,462.00
411 Special | Price Group 3 | £2,539.00
412 Exclusive | Price Group 3 | £2,462.00
413 Exclusive | Price Group 3 | £2,539.00
414 Exlusive | Price Group 3 | £2,594.00
417 Exclusive | Price Group 3 | £2,539.00
418 Special | Price Group 3 | £2,594.00
418 Special | Price Group 3 | £2,594.00
419 Exclusive | Price Group 3 | £2,539.00
420 Exclusive | Price Group 3 | £2,405.00
277 Drake | Price Group 4 | £2,488.00
2BBLTH | Price Group 4 | £2,605.00
2BCB | Price Group 4 | £2,665.00
2BCBA | Price Group 4 | £2,488.00
2BCBA | Price Group 4 | £2,547.00
2BCBSP Special | Price Group 4 | £2,488.00
301 HT | Price Group 4 | £2,750.00
303 Special | Price Group 4 | £2,488.00
304 Tow | Price Group 4 | £2,605.00
341 Special | Price Group 4 | £2,665.00
342 Exclusive | Price Group 4 | £2,750.00
342 Special | Price Group 4 | £2,665.00
350 HT | Price Group 4 | £2,547.00
353 Special | Price Group 4 | £2,547.00
360 Exlcusive | Price Group 4 | £2,547.00
361 Exclusive | Price Group 4 | £2,547.00
363 Exclusive | Price Group 4 | £2,547.00
364 Exclusive | Price Group 4 | £2,547.00
368 Exclusive | Price Group 4 | £2,547.00
369 Exclusive | Price Group 4 | £2,665.00
372 Byron | Price Group 4 | £2,547.00
380 Exclusive | Price Group 4 | £2,605.00
3B5P Sorley | Price Group 4 | £2,547.00
3BH (305) | Price Group 4 | £2,547.00
403 Exclusive | Price Group 4 | £2,547.00
404 HT | Price Group 4 | £2,750.00
405 V1 | Price Group 4 | £2,605.00
406 Exclusive | Price Group 4 | £2,605.00
407 Exclusive | Price Group 4 | £2,665.00
408 Exclusive | Price Group 4 | £2,605.00
410 Exclusive | Price Group 4 | £2,665.00
411 Special | Price Group 4 | £2,750.00
412 Exclusive | Price Group 4 | £2,665.00
413 Exclusive | Price Group 4 | £2,750.00
414 Exlusive | Price Group 4 | £2,809.00
417 Exclusive | Price Group 4 | £2,750.00
418 Special | Price Group 4 | £2,809.00
418 Special | Price Group 4 | £2,809.00
419 Exclusive | Price Group 4 | £2,750.00
420 Exclusive | Price Group 4 | £2,605.00
OPTIONAL [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRICE BAND3 |  |  |  |  |  |  | PRICE BAND 4
CHOICE #1 | Price Group 1 | £265.00
CHOICE #12 | Price Group 1 | £476.00
CHOICE #123 | Price Group 1 | £105.00
CHOICE #1234 | Price Group 1 | £59.00
CHOICE #12345 | Price Group 1 | £128.00
CHOICE #123456 | Price Group 1 | £70.00
CHOICE #1234567 | Price Group 1 | £158.00
CHOICE #12345678 | Price Group 1 | £87.00
CHOICE #123456789 | Price Group 1 | £64.00
NO VALUE | Price Group 1 | 0
CHOICE #1 | Price Group 2 | £287.00
CHOICE #12 | Price Group 2 | £498.00
CHOICE #123 | Price Group 2 | £112.00
CHOICE #1234 | Price Group 2 | £63.00
CHOICE #12345 | Price Group 2 | £138.00
CHOICE #123456 | Price Group 2 | £76.00
CHOICE #1234567 | Price Group 2 | £175.00
CHOICE #12345678 | Price Group 2 | £95.00
CHOICE #123456789 | Price Group 2 | £64.00
NO VALUE | Price Group 2 | 0
CHOICE #1 | 20mm Mirage | £310.00
CHOICE #12 | 20mm Mirage | £581.00
CHOICE #123 | 20mm Mirage | £122.00
CHOICE #1234 | 20mm Mirage | £68.00
CHOICE #12345 | 20mm Mirage | £149.00
CHOICE #123456 | 20mm Mirage | £82.00
CHOICE #1234567 | 20mm Mirage | £191.00
CHOICE #12345678 | 20mm Mirage | £104.00
CHOICE #123456789 | 20mm Mirage | £64.00
NO VALUE | 20mm Mirage | 0
CHOICE #1 | Price Group 3 | £310.00
CHOICE #12 | Price Group 3 | £581.00
CHOICE #123 | Price Group 3 | £122.00
CHOICE #1234 | Price Group 3 | £68.00
CHOICE #12345 | Price Group 3 | £149.00
CHOICE #123456 | Price Group 3 | £82.00
CHOICE #1234567 | Price Group 3 | £191.00
CHOICE #12345678 | Price Group 3 | £104.00
CHOICE #123456789 | Price Group 3 | £64.00
NO VALUE | Price Group 3 | 0
CHOICE #1 | Price Group 4 | £334.00
CHOICE #12 | Price Group 4 | £772.00
CHOICE #123 | Price Group 4 | £132.00
CHOICE #1234 | Price Group 4 | £74.00
CHOICE #12345 | Price Group 4 | £159.00
CHOICE #123456 | Price Group 4 | £88.00
CHOICE #1234567 | Price Group 4 | £207.00
CHOICE #12345678 | Price Group 4 | £112.00
CHOICE #123456789 | Price Group 4 | £64.00
NO VALUE | Price Group 4 | 0