Spreadsheet: 727068d1617701972-sumifs-follow-on-from-countifs-heatherk72-data-help-aligw
Sheet: £251 - £500

Creation Date | Customer | Salesperson | Status | Customer/Industry Segment | Untaxed Amount |  | Total Value | Count | Customer/Industry Segment | Total
2021-02-05 13:56:07 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 252
2021-03-17 11:44:09 | National Museums Scotland | Sandra Urquhart | [NAME] | Leisure | 252
2021-02-01 17:14:48 | Buffalo Farm - Mozzarella Factory | [NAME] | [NAME] | Meat/Butchers | 254
2021-03-08 12:35:38 | Green Commercial Cleaning | [NAME] | [NAME] | Facilities Management (non-rail) | 254.9
2021-02-24 08:57:18 | Lothian Buses Plc (Central)C | [NAME] | [NAME] | Bus Operator | 255.49
2021-03-01 12:05:09 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 258
2021-02-17 16:01:28 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 260.1
2021-02-17 14:58:00 | Gosford Bothy Farm Shop | [NAME] | [NAME] | Miscellaneous | 262.84
2021-03-09 09:20:29 | Hitachi Rail Europe Ltd (First Hull Trains) | [NAME] | [NAME] | [NAME] | 263.5
2021-02-10 14:16:49 | [NAME] Scotland | [NAME] | [NAME] | Leisure | 265
2021-02-05 09:39:24 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 268.56
2021-02-12 16:47:00 | The Assay Office | Sandra Urquhart | [NAME] | Miscellaneous | 269.45
2021-02-15 10:43:04 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 272.24
2021-03-01 11:21:53 | FES FM LTD | [NAME] | [NAME] | Facilities Management (non-rail) | 275
2021-03-02 13:24:53 | FES FM LTD | [NAME] | [NAME] | Facilities Management (non-rail) | 278.4
2021-03-17 10:20:29 | Belhaven Smokehouse Ltd | [NAME] | [NAME] | Food Production | 280
2021-02-08 14:57:23 | [NAME] | [NAME] | [NAME] | Facilities Management (non-rail) | 280.1
2021-02-23 14:11:06 | Branston Ltd | [NAME] | [NAME] | Food Production | 281.4
2021-03-12 13:53:32 | FirstGroup plc - First Bus | [NAME] | [NAME] | Bus Operator | 282.8
2021-03-16 08:44:20 | FirstGroup plc - First Bus | [NAME] | [NAME] | Bus Operator | 282.8
2021-03-16 13:37:53 | FirstGroup plc - First Bus | [NAME] | [NAME] | Bus Operator | 282.8
2021-03-12 16:55:49 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 283.43
2021-02-17 12:17:58 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 285
2021-03-14 08:55:24 | Belhaven Smokehouse Ltd | [NAME] | [NAME] | Food Production | 285.64
2021-02-05 09:07:33 | Travis Perkins Trading Co. Ltd | Sandra Urquhart | [NAME] | Miscellaneous | 286.37
2021-03-12 12:45:42 | [NAME] Ltd | [NAME] | [NAME] | Meat/Butchers | 292.88
2021-03-03 16:58:57 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 294
2021-02-14 22:21:39 | [NAME] Quality Butcher | [NAME] | [NAME] | Meat/Butchers | 296.6
2021-02-04 11:03:41 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 296.7
2021-03-02 13:30:52 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 297
2021-02-22 10:49:55 | Gullane Golf Club | [NAME] | [NAME] | Golf Clubs & Sports Clubs | 299.09
2021-03-10 13:53:52 | Palletways (UK) Ltd | [NAME] | [NAME] | SUPPLIER | 300
2021-03-01 14:41:09 | Denholm Bakers Limited | [NAME] | [NAME] | Bakers | 300.26
2021-03-01 09:46:17 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 302.98
2021-03-07 11:49:17 | [NAME] | [NAME] | [NAME] | Bakers | 305.05
2021-02-17 08:24:00 | [NAME] T/A Lishmans of Ilkley | [NAME] | [NAME] | Meat/Butchers | 306.71
2021-02-25 15:05:36 | Argo's Bakery | [NAME] | [NAME] | Bakers | 307.56
2021-03-08 12:04:24 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 309
2021-02-22 09:45:13 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 309.66
2021-03-12 14:17:27 | G.H. Barnett Bakers | [NAME] | [NAME] | Bakers | 311.14
2021-03-04 10:26:23 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 312.82
2021-02-10 09:30:21 | [NAME] | [NAME] | [NAME] | Meat/Butchers | 320.93
2021-02-22 14:44:29 | T & R Skinner (Butchers) | [NAME] | [NAME] | Meat/Butchers | 323.18
2021-03-12 14:53:14 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 323.29
2021-03-09 11:58:39 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 324
2021-02-17 12:39:42 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 325.82
2021-02-01 16:55:52 | [NAME] (Butchers) | [NAME] | [NAME] | Meat/Butchers | 327.94
2021-02-02 10:00:42 | Dales Traditional Butchers Ltd | [NAME] | [NAME] | Meat/Butchers | 331.7
2021-03-02 08:56:11 | Instock Disposables - customer collection | [NAME] | [NAME] | Distributor (non-rail) | 332
2021-03-16 13:45:11 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 332.44
2021-03-03 15:03:51 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 335.2
2021-03-10 15:29:21 | Hitachi Rail Europe Ltd (GWR) | [NAME] | [NAME] | [NAME] | 342.5
2021-03-19 11:52:56 | Gilead Sciences International | [NAME] | [NAME] | Hospitals & Medical | 344.68
2021-03-17 12:47:50 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 345.02
2021-02-08 09:34:53 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 348
2021-02-18 10:18:10 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 348
2021-03-04 10:08:13 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 348
2021-03-15 13:47:33 | [NAME] (Butchers) | [NAME] | [NAME] | Meat/Butchers | 348.44
2021-02-16 16:19:22 | Travis Perkins Trading Co. Ltd | Sandra Urquhart | [NAME] | Miscellaneous | 350.98
2021-02-11 15:06:46 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 355.5
2021-02-12 10:00:34 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 360
2021-02-15 11:06:38 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 360
2021-02-22 13:04:54 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 360
2021-03-01 09:40:48 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 360
2021-03-15 14:41:49 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 360
2021-02-15 12:58:03 | [NAME] (Bakers) | [NAME] | [NAME] | Bakers | 367.74
2021-03-02 12:09:05 | ChemTX | [NAME] | [NAME] | Engineering & Manufacturing | 369.29
2021-03-02 11:26:12 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 371.88
2021-02-25 16:27:17 | National Museums Scotland | Sandra Urquhart | [NAME] | Leisure | 374.4
2021-03-17 11:36:38 | Travis Perkins Trading Co. Ltd | Sandra Urquhart | [NAME] | Miscellaneous | 375.92
2021-02-02 10:07:35 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 380
2021-02-24 14:07:15 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 384.54
2021-03-01 11:17:38 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 386.89
2021-03-16 11:40:33 | D.G. Lindsay & Son | [NAME] | [NAME] | Meat/Butchers | 391
2021-02-05 09:29:20 | [NAME] (Butchers) Ltd | [NAME] | [NAME] | Meat/Butchers | 391.32
2021-02-18 10:29:56 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 392.98
2021-02-02 13:57:51 | [NAME] (Bakers) | [NAME] | [NAME] | Bakers | 398.47
2021-02-11 11:54:01 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 398.8
2021-02-22 12:07:22 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 403.2
2021-03-04 12:24:30 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 426.74
2021-03-02 09:53:11 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 429.18
2021-03-01 11:52:26 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 432
2021-03-10 13:09:34 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 435.74
2021-03-03 15:52:58 | First MTR South Western Trains Ltd. | [NAME] | [NAME] | Rail TOC | 438
2021-02-11 08:26:33 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 441
2021-03-09 09:43:46 | Hitachi Rail Europe Ltd (GWR) | [NAME] | [NAME] | [NAME] | 444.78
2021-03-01 09:54:57 | First Trenitalia West Coast Rail Limited | [NAME] | [NAME] | Rail TOC | 447.7
2021-02-08 15:22:41 | Travis Perkins Trading Co. Ltd | Sandra Urquhart | [NAME] | Miscellaneous | 448.85
2021-03-11 15:21:50 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 450
2021-02-10 13:37:57 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 450.66
2021-03-19 11:38:15 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 453.6
2021-02-01 12:15:57 | Loch Maddy Hotel | [NAME] | [NAME] | Hotels & Hospitality | 454.06
2021-03-01 13:57:12 | Manor Filling Station | [NAME] | [NAME] | Miscellaneous | 454.92
2021-02-08 13:24:37 | Andersons Quality Butchers | [NAME] | [NAME] | Meat/Butchers | 460.08
2021-03-01 10:13:50 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 464.78
2021-02-01 08:32:14 | Hitachi Rail Europe Limited - Ashford TMC (South Eastern Trains) | [NAME] | [NAME] | [NAME] | 466.2
2021-02-25 09:02:52 | Rail Gourmet UK Ltd | [NAME] | [NAME] | Rail Supplier/Distributor | 469.2
2021-02-16 15:43:15 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 476.82
2021-03-04 09:12:25 | Innovate Foods Ltd | [NAME] | [NAME] | Food Production | 479.1
2021-02-07 17:30:11 | Scott Brothers (Dundee) Ltd | [NAME] | [NAME] | Meat/Butchers | 479.15
2021-03-16 15:12:29 | Hayley Group Plc | [NAME] | [NAME] | Rail Supplier/Distributor | 479.2
2021-02-12 14:14:23 | [NAME] | Sandra Urquhart | [NAME] | Care Homes & Housing Associations | 485.31
2021-02-22 09:02:33 | Atalian Servest Ltd (LNER) | [NAME] | [NAME] | Rail - Facilities Management | 494.57
2021-02-05 09:23:22 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 500
2021-02-05 11:09:14 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 500
2021-02-05 11:13:23 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 500
2021-02-05 11:15:19 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 500
2021-02-05 16:08:17 | East Lothian Council | [NAME] | [NAME] | Government & Local Authorities | 500