Spreadsheet: 727068d1617701972-sumifs-follow-on-from-countifs-heatherk72-data-help-aligw
Sheet: Sheet1

Customer/Industry Segment | Untaxed Amount |  | Customer/Industry Segment | 0 - 50 | 51 - 150 | 151 - 250 | 251 - 500 | 501 - 1000 | 1001 - 5000 | 5000 + |  | 0 - 50 | 51 - 150 | 151 - 250 | 251 - 500 | 501 - 1000 | 1001 - 5000 | 5000 +
Meat/Butchers | 2.58 |  | Bakers
No Segment | 8.71 |  | Bus Operator
Rail Supplier/Distributor | 8.8 |  | Care Homes & Housing Associations
Miscellaneous | 9.95 |  | Distributor (non-rail)
No Segment | 10.2 |  | Engineering & Manufacturing
Meat/Butchers | 10.27 |  | Facilities Management (non-rail)
Facilities Management (non-rail) | 12.39 |  | Fish
Meat/Butchers | 12.48 |  | Food Production
Rail TOC | 15.54 |  | Golf Clubs & Sports Clubs
Miscellaneous | 16.22 |  | Government & Local Authorities
No Segment | 17.4 |  | Hospitals & Medical
Rail - Facilities Management | 17.5 |  | Hotels & Hospitality
Meat/Butchers | 18.35 |  | Leisure
Care Homes & Housing Associations | 18.48 |  | Meat/Butchers
Miscellaneous | 19.2 |  | Miscellaneous
Meat/Butchers | 21.42 |  | No Segment
Meat/Butchers | 21.6 |  | Pubs & Clubs
Government & Local Authorities | 21.9 |  | Rail - Facilities Management
Food Production | 24.14 |  | [NAME]
Bus Operator | 24.5 |  | Rail Supplier/Distributor
Bus Operator | 24.5 |  | Rail TOC
Bus Operator | 24.5 |  | Restaurants & Catering
Miscellaneous | 24.65 |  | Schools & Colleges
Meat/Butchers | 24.77 |  | SUPPLIER
No Segment | 26
Hotels & Hospitality | 26.02
Meat/Butchers | 26.56
Miscellaneous | 29
Facilities Management (non-rail) | 29.75
Engineering & Manufacturing | 29.86
Meat/Butchers | 30.88
Golf Clubs & Sports Clubs | 33.03
Miscellaneous | 33.5
Miscellaneous | 33.5
Care Homes & Housing Associations | 35.61
Rail TOC | 36
Hospitals & Medical | 37.08
Hospitals & Medical | 37.48
Meat/Butchers | 37.86
No Segment | 38.74
Government & Local Authorities | 38.94
Government & Local Authorities | 39
Rail - Facilities Management | 39.52
Restaurants & Catering | 39.59
Meat/Butchers | 40.52
Government & Local Authorities | 41.9
Facilities Management (non-rail) | 42.42
Meat/Butchers | 43.28
Bus Operator | 44
Bus Operator | 44
No Segment | 45.61
Bus Operator | 45.95
Meat/Butchers | 45.99
Bus Operator | 47.42
Facilities Management (non-rail) | 48.04
Government & Local Authorities | 48.41
[NAME] | 48.48
Miscellaneous | 49.43
Meat/Butchers | 50.45
Meat/Butchers | 51.22
Food Production | 52.92
Meat/Butchers | 54.77
Meat/Butchers | 55.84
Meat/Butchers | 56.57
Meat/Butchers | 56.84
Rail TOC | 57
Government & Local Authorities | 58
Bakers | 58.2
Meat/Butchers | 58.8
Meat/Butchers | 59.68
Government & Local Authorities | 61.02
Meat/Butchers | 61.42
Miscellaneous | 63
Bus Operator | 63.5
Meat/Butchers | 65.44
Meat/Butchers | 66.13
Meat/Butchers | 66.24
Meat/Butchers | 67.07
Care Homes & Housing Associations | 67.5
Care Homes & Housing Associations | 67.5
Food Production | 68.22
Meat/Butchers | 69.69
Meat/Butchers | 73.03
Rail Supplier/Distributor | 74.4
Golf Clubs & Sports Clubs | 75
Meat/Butchers | 75.33
Meat/Butchers | 75.77
Care Homes & Housing Associations | 76.04
Restaurants & Catering | 77.76
Bus Operator | 78
Facilities Management (non-rail) | 78.42
Government & Local Authorities | 78.66
Meat/Butchers | 79.12
Engineering & Manufacturing | 80
Facilities Management (non-rail) | 81.3
Meat/Butchers | 81.6
Meat/Butchers | 83.46
Meat/Butchers | 84.39
Government & Local Authorities | 87.6
Meat/Butchers | 88.12
Miscellaneous | 88.26
Government & Local Authorities | 88.95
Meat/Butchers | 90
Care Homes & Housing Associations | 90
Care Homes & Housing Associations | 90
Meat/Butchers | 91.4
Meat/Butchers | 91.53
Meat/Butchers | 93.59
Bakers | 94.91
Rail TOC | 95
Government & Local Authorities | 97.02
Bus Operator | 97.5
Bus Operator | 97.5
Hospitals & Medical | 97.64
Meat/Butchers | 98.58
Meat/Butchers | 98.74
Meat/Butchers | 99.04
Care Homes & Housing Associations | 99.22
Meat/Butchers | 99.6
Rail TOC | 100
Rail - Facilities Management | 100
Rail TOC | 100.5
[NAME] | 100.74
Meat/Butchers | 103.52
Meat/Butchers | 103.84
Meat/Butchers | 104.4
Facilities Management (non-rail) | 104.6
Rail TOC | 105
Meat/Butchers | 105.43
Distributor (non-rail) | 106.56
Rail TOC | 108
Rail TOC | 108
Meat/Butchers | 109.26
Government & Local Authorities | 109.5
Meat/Butchers | 109.83
Meat/Butchers | 112.12
Rail Supplier/Distributor | 114.4
Meat/Butchers | 115.04
Meat/Butchers | 115.04
Meat/Butchers | 115.86
Government & Local Authorities | 116
Miscellaneous | 116.5
Distributor (non-rail) | 117.6
Meat/Butchers | 120.12
Meat/Butchers | 120.32
Meat/Butchers | 121.12
Rail - Facilities Management | 122.7
Golf Clubs & Sports Clubs | 125.71
Meat/Butchers | 125.9
Meat/Butchers | 126.78
Meat/Butchers | 127.04
Meat/Butchers | 129.11
Food Production | 131.44
Care Homes & Housing Associations | 131.92
Facilities Management (non-rail) | 132
Meat/Butchers | 132.82
Rail TOC | 133.2
Rail TOC | 133.2
Meat/Butchers | 134.12
Bus Operator | 135.38
Meat/Butchers | 136.77
Meat/Butchers | 136.8
Meat/Butchers | 137.1
Rail TOC | 144
Rail TOC | 144
Government & Local Authorities | 144
Rail TOC | 144
Hotels & Hospitality | 148.39
Miscellaneous | 150.78
Meat/Butchers | 150.93
Rail TOC | 157.8
Meat/Butchers | 159.34
Food Production | 164.15
Restaurants & Catering | 164.31
Rail TOC | 164.4
[NAME] | 166
Rail TOC | 168
Rail TOC | 168
Meat/Butchers | 170.96
Meat/Butchers | 171.76
Rail TOC | 172.8
Meat/Butchers | 175.83
Government & Local Authorities | 180
Meat/Butchers | 184.15
Meat/Butchers | 185.18
Food Production | 192
Bus Operator | 195
Bus Operator | 195
Bus Operator | 195
Meat/Butchers | 198.24
Restaurants & Catering | 198.44
Government & Local Authorities | 201.6
Care Homes & Housing Associations | 202.2
Miscellaneous | 203.3
Rail Supplier/Distributor | 204.8
Food Production | 208.08
Meat/Butchers | 210.15
Rail TOC | 216
Facilities Management (non-rail) | 216.17
Meat/Butchers | 216.96
Fish | 217.42
[NAME] | 222
[NAME] | 222
Rail TOC | 222
Rail TOC | 225
Rail TOC | 225
Rail - Facilities Management | 236.85
Meat/Butchers | 238.3
Government & Local Authorities | 241.92
Government & Local Authorities | 241.92
Meat/Butchers | 243.74
Meat/Butchers | 247.08
Rail TOC | 252
Meat/Butchers | 254
Bus Operator | 255.49
Government & Local Authorities | 260.1
Miscellaneous | 262.84
Leisure | 265
Meat/Butchers | 268.56
Miscellaneous | 269.45
Meat/Butchers | 272.24
Facilities Management (non-rail) | 280.1
Food Production | 281.4
Rail TOC | 285
Miscellaneous | 286.37
Meat/Butchers | 296.6
Rail - Facilities Management | 296.7
Golf Clubs & Sports Clubs | 299.09
Meat/Butchers | 306.71
Bakers | 307.56
Meat/Butchers | 309.66
Meat/Butchers | 320.93
Meat/Butchers | 323.18
Rail Supplier/Distributor | 325.82
Meat/Butchers | 327.94
Meat/Butchers | 331.7
Rail Supplier/Distributor | 348
Rail Supplier/Distributor | 348
Miscellaneous | 350.98
Rail Supplier/Distributor | 355.5
Rail Supplier/Distributor | 360
Rail Supplier/Distributor | 360
Rail - Facilities Management | 360
Bakers | 367.74
Leisure | 374.4
Rail TOC | 380
Rail Supplier/Distributor | 384.54
Meat/Butchers | 391.32
Rail - Facilities Management | 392.98
Bakers | 398.47
Rail TOC | 398.8
Government & Local Authorities | 403.2
Rail Supplier/Distributor | 441
Miscellaneous | 448.85
Rail Supplier/Distributor | 450.66
Hotels & Hospitality | 454.06
Meat/Butchers | 460.08
[NAME] | 466.2
Rail Supplier/Distributor | 469.2
Government & Local Authorities | 476.82
Meat/Butchers | 479.15
Care Homes & Housing Associations | 485.31
Rail - Facilities Management | 494.57
Government & Local Authorities | 500
Government & Local Authorities | 500
Government & Local Authorities | 500
Government & Local Authorities | 500
Government & Local Authorities | 500
[NAME] | 509.4
Government & Local Authorities | 514.5
Government & Local Authorities | 552.36
Rail - Facilities Management | 566.8
Rail TOC | 570.2
Rail Supplier/Distributor | 573
Rail TOC | 595
Rail TOC | 599
Rail Supplier/Distributor | 644.84
Rail Supplier/Distributor | 712.7
[NAME] | 716.62
Rail Supplier/Distributor | 720
Rail - Facilities Management | 756.75
[NAME] | 756.85
Rail Supplier/Distributor | 765.08
Rail TOC | 795.5
[NAME] | 799.58
Bus Operator | 848.4
Bus Operator | 848.4
Rail - Facilities Management | 856.45
Bus Operator | 877.5
Food Production | 895.4
Meat/Butchers | 944.24
Rail TOC | 985
Meat/Butchers | 989.74
[NAME] | 1101.96
[NAME] | 1159.53
Rail - Facilities Management | 1260.5
Rail - Facilities Management | 1283.31
Food Production | 1289.83
Rail Supplier/Distributor | 1404
Bus Operator | 1414
[NAME] | 1529.2
Rail - Facilities Management | 1584.98
Meat/Butchers | 1586.15
Facilities Management (non-rail) | 1620
Facilities Management (non-rail) | 1633.96
Bus Operator | 1696.8
Rail - Facilities Management | 1845
Rail Supplier/Distributor | 1910.25
Bus Operator | 1979.6
[NAME] | 2187.99
[NAME] | 2187.99
Bus Operator | 2307.2
[NAME] | 2398.7
Bus Operator | 2545.2
Bus Operator | 2828
Bus Operator | 2828
Bus Operator | 3393.6
Bus Operator | 3676.4
Bus Operator | 3676.4
Bus Operator | 3959.2
Bus Operator | 4242
Rail - Facilities Management | 4456
Bus Operator | 4524.8
Bus Operator | 4807.6
Facilities Management (non-rail) | 4893
Bus Operator | 5938.8
Rail - Facilities Management | 7756.63
Bus Operator | 8201.2
Bus Operator | 9615.2
Bus Operator | 10463.6
Bus Operator | 10746.4
Bus Operator | 11029.2
Bus Operator | 13574.4
Bus Operator | 14172.8
Bus Operator | 21492.8
Distributor (non-rail) | 71400