Spreadsheet: 783529d1654883094-sumifs-formula-not-working-correctly-demo-excel
Sheet: Nov 21

GL Code 131640 or 131630 | Raised by | Depot | Supplier | Quantity | Unit Cost | Total Cost | GR'd Yes/No
131640 |  | Transport | JW CROWTHER & SON LTD | 4 | 900
131630 |  | Engineering | DYNO-ROD LTD | 1 | 104
131630 |  | Site Services | COOLTHERM INSTALLATION SERVICES LTD | 1 | 4171.61
131630 |  | Site Services | COMPLETE SHUTTER SERVICES LTD | 1 | 3165
131630 |  | Site Services | HIGHWIRE TESTING SERVICES LTD | 1 | 224
131630 |  | Site Services | LILLEKER BROS LTD | 1 | 1184
131630 |  | Site Services | LANTERN FIRE AND SECURITY LTD | 1 | 4648.92
131640 |  | Site Services | CHUBB FIRE & SECURITY LTD | 1 | 436
131640 |  | Site Services | CHUBB FIRE & SECURITY LTD | 1 | 673
131640 |  | Site Services | CHUBB FIRE & SECURITY LTD | 1 | 1364
131640 |  | Site Services | CHUBB FIRE & SECURITY LTD | 1 | 473
131640 |  | Site Services | GUARDIAN ELECTRICAL COMPLIANCE LTD | 16 | 1200
131640 |  | Site Services | GUARDIAN ELECTRICAL COMPLIANCE LTD | 1 | 1200
131640 |  | Site Services | INITIAL WASHROOM SOLUTIONS | 1 | 9481.19
131640 |  | Site Services | INITIAL WASHROOM SOLUTIONS | 1 | 9481.19
131640 |  | Site Services | INITIAL WASHROOM SOLUTIONS | 1 | 9481.19
131640 |  | Site Services | INITIAL WASHROOM SOLUTIONS | 1 | 9481.19
131640 |  | Site Services | RENTOKIL INITIAL PEST CONTROL | 1 | 4862.5
131640 |  | Site Services | RENTOKIL INITIAL PEST CONTROL | 1 | 4862.5
131640 |  | Site Services | RENTOKIL INITIAL PEST CONTROL | 1 | 4862.5
131640 |  | Site Services | RENTOKIL INITIAL PEST CONTROL | 1 | 4862.5
131630 |  | M110 | COOLTHERM INSTALLATION SERVICES LTD | 1 | 4248.58
131630 |  | M110 | NRC SERVICES LIMITED | 1 | 100
131630 |  | M110 | LILLEKER BROS LTD | 1 | 514.8
131630 |  | M110 | WHITTAN INDUSTRIAL T/A LINK 51 | 1 | 1808.62
131630 |  | M110 | NRC SERVICES LIMITED | 1 | 100
131630 |  | M110 | NRC SERVICES LIMITED | 1 | 101.4
131630 |  | M110 | NRC SERVICES LIMITED | 1 | 400
131630 |  | M110 | NRC SERVICES LIMITED | 1 | 1079.88
131630 |  | M110 | LILLEKER BROS LTD | 1 | 384.47
131640 |  | M110 | SEE SERVICES | 1 | 126.25
131640 |  | M110 | JW CROWTHER & SON LTD | 2 | 178
131640 |  | M110 | TRUSTCLEAN LTD | 1 | 656
131640 |  | Peterborough Depot | SEE SERVICES | 1 | 872.63
131640 |  | Peterborough Depot | SEE SERVICES | 1 | 1447
131630 |  | Warrington Depot | SEE SERVICES | 1 | 392.57
131640 |  | Warrington Depot | DYNO-ROD LTD | 1 | 2690
131640 |  | Warrington Depot | NRC SERVICES LIMITED | 1 | 300
131630 |  | Newton Depot | [NAME] PROPERTY SERVICES (SCOTLAN | 1 | 100
131640 |  | Newton Depot | ARCO LTD | 1 | 166.68
131640 |  | Newton Depot | BRITISH GAS | 1 | 500
131930 |  | Newton Depot | ENTERPRISE WORKWEAR LTD | 1 | 564.9
131640 |  | Carmarthen Depot | BC SERVICES T/A DYNO-ROD | 1 | 850
131640 |  | West London Depot | BC SERVICES T/A DYNO-ROD | 1 | 150
131640 |  | West London Depot | COLSHAW CONSTRUCTION GROUP | 1 | 1143.6
131640 |  | West London Depot | COLSHAW CONSTRUCTION GROUP | 1 | 47.65
131640 |  | West London Depot | COLSHAW CONSTRUCTION GROUP | 1 | 953
131640 |  | West London Depot | COMPLETE SHUTTER SERVICES LTD | 1 | 558
131640 |  | West London Depot | LANTERN FIRE AND SECURITY LTD | 1 | 275
131640 |  | West London Depot | LEMARK OFFICE EQUIPMENT | 1 | 420
131640 |  | West London Depot | NATIONWIDE FRANKING SENSE LTD | 1 | 234.98
131640 |  | West London Depot | RENTOKIL INITIAL PEST CONTROL | 1 | 1605
131640 |  | West London Depot | SEE SERVICES | 1 | 1572.45
131640 |  | West London Depot | SEE SERVICES | 1 | 1096.09
131640 |  | West London Depot | SARA LOADING BAY SPECIALISTS | 1 | 1662.98
131640 |  | West London Depot | S. TYSOE INSTALLATIONS | 1 | 125
131640 |  | West London Depot | TOTAL MAINTENANCE UK LTD | 1 | 185
131640 |  | West London Depot | KLIPSPRINGER | 1 | 124.46
131640 |  | West London Depot | LESAR UK LTD | 1 | 476.5
131640 |  | West London Depot | TOTAL MAINTENANCE UK LTD | 1 | 240
131630 |  | Southampton Depot | D-TECT SECURITY SYSTEMS LTD | 1 | 330
131630 |  | Southampton Depot | HP CONTRACTS LTD | 1 | 168.78
131640 |  | Stonehouse Depot | [NAME] | 1 | 195
131640 |  | Stonehouse Depot | [NAME] | 1 | 1350
131640 |  | [NAME] | LEMARK OFFICE EQUIPMENT | 1 | 882
131640 |  | [NAME] | OUTSOURCE CLEANING LTD | 1 | 250
131640 |  | [NAME] | SEE SERVICES | 1 | 744.98
131640 |  | East Kilbride Depot | [NAME] PROPERTY SERVICES (SCOTLAN | 1 | 495
131640 |  | East Kilbride Depot | [NAME] PROPERTY SERVICES (SCOTLAN | 1 | 1613.2
131630 |  | Tamworth | HORMANN | 1 | 135
131630 |  | Tamworth | WHITTAN INDUSTRIAL T/A LINK 51 | 1 | 929
131630 |  | Tamworth | PHS COMPLIANCE | 1 | 647.3
131630 |  | Tamworth | PHS COMPLIANCE | 1 | 1270
131630 |  | Tamworth | TRIDENT RENTALS LTD | 1 | 1560
131640 |  | Tamworth | KONE DOORS | 1 | 321.75
131640 |  | Tamworth | KONE DOORS | 1 | 399.6
131640 |  | Tamworth | NRC SERVICES LIMITED | 1 | 2546.9
131640 |  | Tamworth | NRC SERVICES LIMITED | 1 | 300
131640 |  | Plymouth | D-TECT SECURITY SYSTEMS LTD | 1 | 450
131630 |  | WYMONDHAM | SEE SERVICES | 1 | 976.64
131630 |  | WYMONDHAM | SEE SERVICES | 1 | 172.5
131640 |  | Exeter | DALE BUILDING MAINTENANCE LTD | 1 | 1023.25
131640 |  | Exeter | DALE BUILDING MAINTENANCE LTD | 1 | 505.82
131640 |  | Exeter | DALE BUILDING MAINTENANCE LTD | 1 | 1745.2
131640 |  | Exeter | DALE BUILDING MAINTENANCE LTD | 1 | 1094.22
131640 |  | Exeter | DALE BUILDING MAINTENANCE LTD | 1 | 915
131640 |  | Exeter | D.TEC INTERNATIONAL | 1 | 1767
131640 |  | Exeter | D-TECT SECURITY SYSTEMS LTD | 1 | 1767
1234 |  | Carmarthen | [NAME] | 1 | 20