Spreadsheet: 45758d1244568999-sumproduct-formula-throwing-out-values-order-and-project-bank-2009-2010
Sheet: Current Orders

Cash Contract No | Cash Job No. | Date Received | Salesman | Cash [NAME] | Client | System Type | Order Number | Deposit | Total Project Value | Predicted Invoice Month | Predicted Invoice Amount By  Month | Invoice Value Outstanding | 1st Invoiced Total | Date Of 1st Invoice | 2nd Invoiced Total | Date Of  2nd Invoice | 3rd Invoiced Total | Date Of  3rd Invoice | 4th Invoiced Total | Date Of  4th Invoice | Project Completed Y/N | [NAME] | Installed by Service Team (Y) | Notes
3635 |  | 2007-07-26 00:00:00 | [NAME] | Enq 109 |  | [NAME] | PO32251 |  | 825 | 2009-06-01 00:00:00 | 825 | 825 |  |  |  |  |  |  |  |  |  |  |  |  | 1
6425 | 61055 | 2008-04-10 00:00:00 | [NAME] | ENQ661 |  | IAS | L/00 22612 |  | 2250 | 2009-06-01 00:00:00 | 2250 | 2250
 |  | 2008-04-22 00:00:00 | [NAME] | ENQ419 |  | IAS, CCTV and Video entry | Email verification |  | 17326 | 2009-04-01 00:00:00 | 17326 | 4999.5 | 4331.5 | 2008-05-01 00:00:00 | 7995 | 2009-03-01 00:00:00
 |  | 2008-07-31 00:00:00 | [NAME] | ENQ738 |  | CCTV, IAS, Access Control | 12s/e sc17509 |  | 60000 | 2009-05-01 00:00:00 | 60000 | 60000
7096 | 64256/64257 | 4th Sept 08 | [NAME] | ENQ419 |  | Video entry and CCTV additions | email verification |  | 3161 | 2009-04-01 00:00:00 | 3161 | 161 | 3000 | 2009-03-01 00:00:00
 |  | 2008-10-23 00:00:00 | [NAME] | ENQ1023 |  | CCTV External Monitoring | 6051 |  | 11834 | 2009-04-01 00:00:00 | 11834 | 2020 | 9814 | 2008-10-01 00:00:00
 |  | 2008-11-06 00:00:00 | [NAME] | ENQ1068 |  | CCTV | ARC-SR-061108-STPANCRAS |  | 1937 | 2009-04-01 00:00:00 | 1937 | 1937
 |  | 2008-11-20 00:00:00 | [NAME] | ENQ1048 |  | IAS | SC 871/016 |  | 3939 | 2009-04-01 00:00:00 | 3939 | 2689 | 1250 | 2009-01-01 00:00:00
 |  | 2008-12-12 00:00:00 | [NAME] | ENQ1158 |  | IAS additions | Invoiced |  | 550 | 2009-04-01 00:00:00 | 550 | 550
 |  | 2008-12-15 00:00:00 | [NAME] | ENQ860 |  | IAS, CCTV & Fire | 07 91 |  | 20000 | 2009-05-01 00:00:00 | 20000 | 15000 | 5000 | 2009-03-01 00:00:00
 |  | 2009-01-13 00:00:00 | [NAME] | ENQ805 |  | Security Access/ Intruder/CCTV | e-mail Of Intent |  | 11181 | 2009-08-01 00:00:00 | 11181 | 11181
 |  | 2009-01-19 00:00:00 | Pau | ENQ1094 |  | [NAME] | ME/2291333 |  | 19909.29 | 2009-04-01 00:00:00 | 19909.29 | 19909.29
 |  | 2009-02-23 00:00:00 | [NAME] | [NAME] |  | Integrated System with Analytics | Deposit | £20,000+vat | 169242 | 2009-05-01 00:00:00 | 169242 | 149242 | 20000 | 2009-01-01 00:00:00
 |  | 2009-03-03 00:00:00 | [NAME] | [NAME] |  | Mastersuit | e-Mail |  | 285 | 2009-04-01 00:00:00 | 285 | 285
 |  | 2009-03-05 00:00:00 | [NAME] | [NAME] |  | CCTV | M0671/4102 |  | 2998 | 2009-04-01 00:00:00 | 2998 | 2998
 |  | 2009-03-23 00:00:00 | [NAME] | ENQ1161A |  | CCTV & Access | Email - order to follow |  | 29432 | 2009-04-01 00:00:00 | 29432 | 29432
 |  | 2009-03-27 00:00:00 | [NAME] | ENQ738 |  | CCTV/INTRUDER/DISABLE | 12S/E SC17509 |  | 10789 | 2009-05-01 00:00:00 | 10789 | 10789
 |  | 2009-04-27 00:00:00 | [NAME] | ENQ1360REV2 |  | Access | Letter if intent |  | 18448 | 2009-05-01 00:00:00 | 18448 | 18448
 |  | 2009-04-30 00:00:00 | [NAME] | ENQ 1353 |  | Access Control | In The Post |  | 822 | 2009-04-01 00:00:00 | 822 | 822
 |  | 2009-04-30 00:00:00 | [NAME] | ENQ844 |  | Locking | E-MAIL |  | 844 | 2009-04-01 00:00:00 | 844 | 844
 |  | 2009-04-30 00:00:00 | [NAME] | ENQ1324 |  | Locking | 131055045 |  | 1330 | 2009-04-01 00:00:00 | 1330 | 1330
 |  | 2009-05-05 00:00:00 | [NAME] | ENQ1363 |  | Camera Relocation | F101667 |  | 397 | 2009-04-01 00:00:00 | 397 | 397
 |  | 2009-05-07 00:00:00 | [NAME] | SHOP |  | Locks | PAID IN FULL | 1 | 350 | 2009-04-01 00:00:00 | 350 | 350
 |  | 2009-05-12 00:00:00 | [NAME] | ENQ1337A |  | Access, CCTV | [NAME] with PO to follow |  | 63136 | 2009-04-01 00:00:00 | 63136 | 63136
 |  | 2009-05-14 00:00:00 | Sean | ENQ1435 |  | Access & Audio Entry | 131055692 |  | 4976 | 2009-04-01 00:00:00 | 4976 | 4976
 |  | 2009-05-18 00:00:00 | [NAME] | ENQ1443 |  | Locking | 3195710-3195696 |  | 660 | 2009-04-01 00:00:00 | 660 | 660
 |  | 2009-05-18 00:00:00 | [NAME] | [NAME] |  | Intruder System | Deposit |  | 1301 | 2009-04-01 00:00:00 | 1301 | 1301
 |  | 2009-05-19 00:00:00 | [NAME] | ENQ1449 |  | Access | Email from [NAME] |  | 273 | 2009-04-01 00:00:00 | 273 | 0 | 273 | 2009-05-01 00:00:00 |  |  |  |  |  |  | Y
 |  | 2009-05-26 00:00:00 | [NAME] | ENQ1423 |  | Accees/Auto Door/CCTV | PO 8335 |  | 13870 | 2009-04-01 00:00:00 | 13870 | 13870
 |  | 2009-05-27 00:00:00 | [NAME] | ENQ1035 |  | Intruder | P33412 |  | 799 | 2009-04-01 00:00:00 | 799 | 799
 |  | 2009-05-27 00:00:00 | [NAME] | ENQ1056 |  | CCTV | E-Mail Form [NAME] |  | 15171 | 2009-04-01 00:00:00 | 15171 | 15171
 |  | 2009-05-28 00:00:00 | [NAME] | ENQ1431B |  | IAS | Email Intent |  | 16116 | 2009-04-01 00:00:00 | 16116 | 0 | 16116 | 2009-05-01 00:00:00 |  |  |  |  |  |  | Y
 |  | 2009-05-29 00:00:00 | [NAME] | ENQ1358A |  | Access | 5948 |  | 3153 | 2009-04-01 00:00:00 | 3153 | 3153
 |  | 2009-06-03 00:00:00 | [NAME] | ENQ1472 |  | CCTV additions | [NAME] |  | 1095
 |  | 2009-06-02 00:00:00 | [NAME] | [NAME] |  | CCTV Rack | 20027885 - 000 OG |  | 2220.4
 |  | 2009-06-04 00:00:00 | [NAME] | N/A |  | 100no. Access Cards | PO09651 |  | 473
 |  | 2009-06-04 00:00:00 | [NAME] | ENQ1447 |  | Access & Audio | [NAME] |  | 4394
 |  | 2009-06-05 00:00:00 | [NAME] | ENQ1458 |  | Access Control | POAG/ED |  | 7440
 |  | 2009-06-08 00:00:00 | [NAME] | N/A |  | Training | 6021566 |  | 560
 |  | 8th June 2009 | [NAME] | ENQ1106A |  | Access Control | 70 |  | 70038