Spreadsheet: 107963d1305089141-excel-2007-sumif-error-when-using-data-from-drop-down-list-excel-issue-with-sumif
Sheet: Workings

Suburb/City | Regions
 |  | Sales
Albany | Auckland Region | 3
Alexandra | Otago Region | 2
Amberley | Canterbury Region | 0
Arrowtown | Otago Region | 3
Ashburton | Canterbury Region | 0
Auckland | Auckland Region | 37
Avonhead | Canterbury Region | 2
Balclutha | Otago Region | 2
Bay of Island | Canterbury Region | 10
Bay of Plenty | Bay Of Plenty Region | 2
Birkenhead | Auckland Region | 12
[NAME] | Marlborough Region | 9
[NAME] | Auckland Region | 8
Cambridge | Waikato Region | 6
Canterbury | Canterbury Region | 5
Carterton | Wellington Region | 6
Christchurch | Canterbury Region | 18
Churton Park | Wellington Region | 0
clive | [NAME]'s Bay Region | 3
Coromandel | Waikato Region | 3
Cromwell | Otago Region | 3
[NAME] | Manawatu-Wanganui Region | 5
[NAME] | Canterbury Region | 4
Dargaville | Northland Region | 5
Daysbay | Wellington Region | 65
Dunedin | Otago Region | 32
Featherston | Wellington Region | 32
Feilding | Manawatu-Wanganui Region | 9
[NAME] | Manawatu-Wanganui Region | 2
Geraldine | Canterbury Region | 23
Gisborne | Gisborne Region | 8
[NAME] | Auckland Region | 21
[NAME] | Southland Region | 3
Great Barrier Island | Auckland Region | 11
Greymouth | West Coast Region | 56
[NAME] | Waikato Region | 44
Hastings | [NAME]'s Bay Region | 11
[NAME] | [NAME]'s Bay Region | 32
[NAME] | Taranaki Region | 2
Hawkes Bay | [NAME]'s Bay Region | 6
Helensville | Auckland Region | 12
Henderson | Auckland Region | 45
Hibiscus Coast | Auckland Region | 16
Hokitika | West Coast Region | 12
Howick | Auckland Region | 2
Invercargill | Southland Region | 9
[NAME] | Canterbury Region | 23
Kaitaia | Northland Region | 2
[NAME] | Northland Region | 12
Kawerau | Bay Of Plenty Region | 65
[NAME] | Manawatu-Wanganui Region | 2
Kerikeri | Northland Region | 6
Lake Tekapo | Canterbury Region | 2
Leeston | Canterbury Region | 1
[NAME] | Manawatu-Wanganui Region | 32
Lower Hutt | Wellington Region | 15
Lyttelton | Canterbury Region | 3
Manawatu | Manawatu-Wanganui Region | 123
Mangere | Auckland Region | 57
Manukau | Auckland Region | 12
[NAME] | Auckland Region | 45
Marlborough | Marlborough Region | 12
Martinborough | Wellington Region | 32
[NAME] | Manawatu-Wanganui Region | 45
Massey | Auckland Region | 6
Masterton | Wellington Region | 7
Matamata | Waikato Region | 54
Miramar | Wellington Region | 78
[NAME] | Waikato Region | 98
Motueka | Tasman Region | 3
Mount Maunganui | Bay Of Plenty Region | 2
Murchison | Tasman Region | 2
Napier | [NAME]'s Bay Region | 8
[NAME] | [NAME] | 29
New Plymouth | Taranaki Region | 17
Ngaruawahia | Waikato Region | 98
North Canterbury | Canterbury Region | 2
North Shore | Auckland Region | 45
Northland | Northland Region | 8
Oamaru | Otago Region | 61
Ohakune | Manawatu-Wanganui Region | 3
Ohope | Bay Of Plenty Region | 78
Opunake | Taranaki Region | 54
Opotiki | Bay Of Plenty Region | 3
Orewa | Auckland Region | 16
Otaki | Wellington Region | 2
Otorohanga | Waikato Region | 2
Otumoetai | Bay Of Plenty Region | 7
Oxford | Canterbury Region | 98
Paekakariki | Wellington Region | 2
[NAME] | Manawatu-Wanganui Region | 2
Pakuranga | Auckland Region | 54
Palmerston | Otago Region | 2
Palmerston North | Manawatu-Wanganui Region | 15
Papakura | Auckland Region | 5
Papamoa | Bay Of Plenty Region | 2
papatoetoe | Auckland Region | 65
Paraparaumu | Wellington Region | 2
Picton | Marlborough Region | 3
Pleasant Point | Canterbury Region | 3
Plimmerton | Wellington Region | 2
[NAME], Dargaville | Northland Region | 4
Pokeno | Auckland Region | 5
Porirua | Wellington Region | 7
Pukekohe | Auckland Region | 5
Putaruru | Waikato Region | 2
Queenstown | Otago Region | 13
[NAME] | Waikato Region | 1
Raumati south | Wellington Region | 2
Rangiora | Canterbury Region | 7
[NAME] | Auckland Region | 2
Rolleston | Canterbury Region | 3
Rotorua | Bay Of Plenty Region | 11
[NAME] | Northland Region | 3
South Island | Otago Region | 4
Southland | Southland Region | 4
Stokes Valley | Wellington Region | 2
[NAME] | Taranaki Region | 65
Tairua | Waikato Region | 5
Takaka | Tasman Region | 6
Taradale | [NAME]'s Bay Region | 6
Taranaki | Taranaki Region | 3
Taumarunui | Manawatu-Wanganui Region | 6
[NAME] | Waikato Region | 4
Tauranga | Bay Of Plenty Region | 24
Te Anau | Southland Region | 2
Te Aroha | Waikato Region | 3
Te Awamutu | Waikato Region | 3
[NAME] | Waikato Region | 3
Te Puke | Bay Of Plenty Region | 3
Thames | Waikato Region | 5
Timaru | Canterbury Region | 5
Titirangi | Auckland Region | 4
Tokoroa | Waikato Region | 3
[NAME] | Auckland Region | 2
Twizel | Canterbury Region | 45
Unknown |  | 3
Upper Hutt | Wellington Region | 5
Waiheke Island | Auckland Region | 0
[NAME] | Waikato Region | 0
Waikanae | Wellington Region | 2
Waikato | Waikato Region | 2
Wainuiomata | Wellington Region | 4
[NAME] | Otago Region | 4
Waipukurau | [NAME]'s Bay Region | 4
Waitakere | Auckland Region | 7
Waitara | Taranaki Region | 3
Waiuku | Auckland Region | 3
[NAME] | Otago Region | 6
Wanganui | Manawatu-Wanganui Region | 11
Warkworth | Auckland Region | 2
Wellington | Wellington Region | 77
Wellsford | Auckland Region | 2
Westport | West Coast Region | 5
Whakatane | Bay Of Plenty Region | 3
Whangamata | Waikato Region | 2
Whanganui | Manawatu-Wanganui Region | 2
[NAME] | Auckland Region | 6
Whangarei | Northland Region | 14