Spreadsheet: 746790d1631027715-multiple-sumifs-sum-ifs-test
Sheet: Sheet1

Date | Weekending | Customer | Tool | Delivery Note | No. Pallets | Total Pallets | Stackable? | Post Code | Zone | No. Lifts | Round Up | Zone/Pallets | Cost |  |  | NO | Yes
2021-08-02 00:00:00 |  | Becton | 12086 | D024861 | 16 |  |  | SN |  |  |  |  |  |  | 2021-08-08 00:00:00
2021-08-02 00:00:00 |  | Becton | 12086 | D024860 | 16 |  |  | SN
2021-08-02 00:00:00 |  | UVA | 15525 | D024864 | 24 |  |  | LE
2021-08-02 00:00:00 |  | Leeds | 16943B | D024862 | 26 |  |  | LS
2021-08-02 00:00:00 |  | Leeds | 17003B | D024863 | 26 |  |  | LS
2021-08-03 00:00:00 |  | Sinclair | 10695 | D024893 | 1 |  |  | DN
2021-08-04 00:00:00 |  | Apollo | 10997 | D024896 | 2 |  |  | PO
2021-08-04 00:00:00 |  | Welland | 15145 | D024897 | 2
2021-08-04 00:00:00 |  | Welland | 16914 | D024898 | 4
2021-08-05 00:00:00 |  | Accord | 17016 | D024907 | 9 |  |  | NE
2021-08-05 00:00:00 |  | Apollo | 9999 | D024908 | 1 |  |  | PO
2021-08-05 00:00:00 |  | Apollo | 10997 | D024909 | 3 |  |  | PO
2021-08-05 00:00:00 |  | Apollo | 10998 | D024910 | 1 |  |  | PO
2021-08-05 00:00:00 |  | Black and Decker | 10778 | D024911 | 2 |  |  | S
2021-08-05 00:00:00 |  | Black and Decker | 15815 | D024912 | 2 |  |  | S
2021-08-05 00:00:00 |  | Leeds | 17003B | D024913 | 52 |  |  | LS
2021-08-05 00:00:00 |  | Lindt | 17081 | D024914 | 52 |  |  | [NAME]
2021-08-05 00:00:00 |  | Remel | 14714 | D024915 | 2 |  |  | DA
2021-08-05 00:00:00 |  | [NAME] | 13853 | D024916 | 1 |  |  | D
2021-08-05 00:00:00 |  | [NAME] | 13853 | D024917 | 3 |  |  | D
2021-08-05 00:00:00 |  | [NAME] | 13866 | D024918 | 11 |  |  | D
2021-08-06 00:00:00 |  | Becton | 14261 | D024922 | 16 |  |  | SN
2021-08-06 00:00:00 |  | Becton | 13838 | D024921 | 16 |  |  | SN
2021-08-06 00:00:00 |  | [NAME] | 17152 | D024923 | 7 |  |  | WA
2021-08-09 00:00:00 |  | Apollo | 9997 | D024927 | 1 |  |  | PO
2021-08-09 00:00:00 |  | Astrazeneca | 16535 | D024928 | 31 |  |  | SK
2021-08-10 00:00:00 |  | Apollo | 10997 | D024939 | 2 |  |  | PO
2021-08-10 00:00:00 |  | Apollo | 10998 | D024938 | 2 |  |  | PO
2021-08-11 00:00:00 |  | Apollo | 10997 | D024941 | 6 |  |  | PO
2021-08-11 00:00:00 |  | Black and Decker | 17156 | D024942 | 2 |  |  | S
2021-08-11 00:00:00 |  | Lindt | 17081 | D024943 | 52 |  |  | [NAME]
2021-08-12 00:00:00 |  | CSM | 14038 | D024945 | 2 |  |  | RH
2021-08-12 00:00:00 |  | Clevtec | 11072 | D024946 | 1 |  |  | WS
2021-08-12 00:00:00 |  | Clevtec | 11084 | D024947 | 1 |  |  | WS
2021-08-12 00:00:00 |  | Smurfitt | 16382 | D024949 | 15 |  |  | CA
2021-08-12 00:00:00 |  | Sovrin | 8184 | [NAME] | 10 |  |  | SL
2021-08-16 00:00:00 |  | Apollo | 10998 | D024956 | 2 |  |  | PO
2021-08-16 00:00:00 |  | Black and Decker | 13895 | D024960 | 1 |  |  | S
2021-08-16 00:00:00 |  | Chester | 16978 | D024961 | 2 |  |  | CH
2021-08-16 00:00:00 |  | Chester | 13977 | D024962 | 5 |  |  | CH
2021-08-16 00:00:00 |  | Chester | 17159 | D024963 | 8 |  |  | CH
2021-08-16 00:00:00 |  | Leeds | 17003B | D024964 | 26 |  |  | LS
2021-08-16 00:00:00 |  | Leeds | 16943B | D024965 | 26 |  |  | LS
2021-08-16 00:00:00 |  | Welland | 16914 | D024966 | 4 |  |  | RH
2021-08-19 00:00:00 |  | Apollo | 10997 | [NAME] | 4 |  |  | PO
2021-08-19 00:00:00 |  | [NAME] and [NAME] | 14518 | D024987 | 2 |  |  | NN
2021-08-19 00:00:00 |  | [NAME] | 13852 | D024988 | 6 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 13853 | D024989 | 3 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 13866 | D024990 | 12 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 13866 | [NAME] | 9 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 14593 | D024992 | 3 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 14593 | D024993 | 3 |  |  | D
2021-08-19 00:00:00 |  | [NAME] | 14593 | D024994 | 1 |  |  | D
2021-08-20 00:00:00 |  | Becton | 13838 | D024996 | 16 |  |  | PO
2021-08-20 00:00:00 |  | Becton | 13838 | D024997 | 16 |  |  | PO
2021-08-20 00:00:00 |  | Leeds | 17003B | D024998 | 52 |  |  | LS
2021-08-20 00:00:00 |  | March Foods | 13912 | D024999 | 1 |  |  | PE
2021-08-20 00:00:00 |  | March Foods | 13913 | D025000 | 1 |  |  | PE
2021-08-20 00:00:00 |  | Ringtons | 14424 | D025001 | 1 |  |  | NE
2021-08-23 00:00:00 |  | Apollo | 10997 | D025005 | 5 |  |  | PO
2021-08-23 00:00:00 |  | Becton | 13838 | D025006 | 16 |  |  | SN
2021-08-23 00:00:00 |  | Becton | 17045 | D025007 | 4 |  |  | SN
2021-08-23 00:00:00 |  | Becton | 17045 | D025008 | 3 |  |  | SN
2021-08-23 00:00:00 |  | Becton | 17046 | D025009 | 4 |  |  | SN
2021-08-23 00:00:00 |  | Becton | 17046 | D025010 | 3 |  |  | SN
2021-08-23 00:00:00 |  | Black and Decker | 12100 | D025011 | 2 |  |  | S
2021-08-23 00:00:00 |  | Black and Decker | 12597 | D025012 | 1 |  |  | S
2021-08-23 00:00:00 |  | Leeds | 16943B | [NAME] | 26 |  |  | LS
2021-08-23 00:00:00 |  | Leeds | 17003B | D025014 | 26 |  |  | LS
2021-08-24 00:00:00 |  | Becton | 17045 | D025016 | 2 |  |  | SN
2021-08-24 00:00:00 |  | Becton | 17045 | D025017 | 2 |  |  | SN
2021-08-24 00:00:00 |  | UVA | 15526L | D025018 | 2 |  |  | LE
2021-08-24 00:00:00 |  | UVA | 15526E | D025018 | 2 |  |  | LE
2021-08-24 00:00:00 |  | Profoot | 15563 | D025019 | 13 |  |  | LU
2021-08-25 00:00:00 |  |  |  |  |  |  |  | DN
2021-08-26 00:00:00 |  | Apollo | 10997 | D025028 | 5 |  |  | PO
2021-08-26 00:00:00 |  | Apollo | 17056 | D025029 | 1 |  | NO | PO
2021-08-26 00:00:00 |  | Crowther | 16733 | [NAME] | 5 |  |  | TN
2021-08-26 00:00:00 |  | Leeds | 17003B | D025031 | 52 |  |  | LS
2021-08-26 00:00:00 |  | Fisher | 17066 | D025032 | 16 |  |  | RH
2021-08-26 00:00:00 |  | SpotSpot | 16121 | D025034 | 16 |  |  | N
2021-08-26 00:00:00 |  | [NAME] | 13852 | D025035 | 12 |  |  | D
2021-08-26 00:00:00 |  | [NAME] | 13853 | D025036 | 4 |  |  | D
2021-08-26 00:00:00 |  | [NAME] | 13866 | D025037 | 8 |  |  | D
2021-08-26 00:00:00 |  | [NAME] | 13866 | D025038 | 8 |  |  | D
2021-09-02 00:00:00 |  | Apollo | 9997 | D025064 | 2 |  |  | PO
2021-09-02 00:00:00 |  | Apollo | 10997 | D025065 | 5 |  |  | PO
2021-09-02 00:00:00 |  | Leeds | 16943B | D025066 | 26 |  |  | LS
2021-09-02 00:00:00 |  | Leeds | 17003B | D025067 | 26 |  |  | LS
2021-09-02 00:00:00 |  | [NAME] | 13853 | D025068 | 1 |  |  | D
2021-09-02 00:00:00 |  | [NAME] | 13866 | D025069 | 19 |  |  | D
2021-09-02 00:00:00 |  | [NAME] | 13866 | D025070 | 3 |  |  | D
2021-09-02 00:00:00 |  | [NAME] | 14593 | D025071 | 1 |  |  | D
2021-09-03 00:00:00 |  | Becton | 13838 | D025082 | 16 |  |  | SN
2021-09-03 00:00:00 |  | Becton | 12086 | D025081 | 16 |  |  | SN
2021-09-03 00:00:00 |  | [NAME] | 12462 | D025083 | 9 |  |  | CM
2021-09-03 00:00:00 |  | VTL | 16217 | D025084 | 1 |  |  | HD
2021-09-03 00:00:00 |  | VTL | 16218 | D025085 | 2 |  |  | HD
2021-09-06 00:00:00 |  | Apollo | 10997 | [NAME] | 3 |  |  | PO
2021-09-06 00:00:00 |  | Apollo | 10998 | [NAME] | 1 |  |  | PO
2021-09-06 00:00:00 |  | Becton | 13838 | D025091 | 16 |  |  | SN
2021-09-07 00:00:00 |  | Becton | 12086 | D025095 | 16 |  |  | SN
2021-09-07 00:00:00 |  | Becton | 13838 | D025096 | 16 |  |  | SN
2021-09-07 00:00:00 |  | Lindt | 17081 | D025097 | 52 |  |  | [NAME]
2021-09-08 00:00:00 |  | Gourmet | 14252 | D025100 | 2 |  |  | NG
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN
 |  |  |  |  |  |  |  | DN