Spreadsheet: 67841d1268346229-index-modification-6wr-3780001
Sheet: 6WR-3780001

Account | Customer | Quantity | UM | Price | Document # | Rep | Date | Type | Discount | Cost | Tax Code | Revenue Account | Expense Account | Location/Sub-Location | Net Price | Week Created | Month Created | Total Charge
403335 | [NAME] | 1 | EA | 949 | SO-5175557 | NLE | 2009-01-28 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 5,2009 | 2009, 1
407507 | [NAME] | 1 | EA | 949 | SO-5179199 | NLE | 2009-02-21 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 8,2009 | 2009, 2
409321 | [NAME] | 1 | EA | 949 | SO-5180615 | NLE | 2009-03-05 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 10,2009 | 2009, 3
409839 | [NAME] | 1 | EA | 949 | SO-5181086 | NLE | 2009-03-09 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 11,2009 | 2009, 3
412856 | [NAME] | 1 | EA | 949 | SO-5183673 | NLE | 2009-03-31 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 14,2009 | 2009, 3
412993 | [NAME] | 1 | EA | 949 | SO-5183802 | NLE | 2009-04-01 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 949 | WEEK 14,2009 | 2009, 4
413594 | [NAME] | 1 | EA | 920 | SO-5184307 | GT | 2009-04-06 00:00:00 | [NAME] | 0 | 602.6 | EXEMPT |  |  | MAIN | 920.0000000000001 | WEEK 15,2009 | 2009, 4
414766 | [NAME] | 1 | EA | 949 | SO-5185367 | NLE | 2009-04-15 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 949 | WEEK 16,2009 | 2009, 4
109260 | [NAME] | 1 | EA | 939 | SO-5186812 | NLE | 2009-04-25 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 939 | WEEK 17,2009 | 2009, 4
417207 | [NAME] | 1 | EA | 939 | SO-5187653 | NLE | 2009-04-30 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 939 | WEEK 18,2009 | 2009, 4
417528 | Wilson's Wilderness Landscaping Inc. | 1 | EA | 789 | SO-5187951 | MS | 2009-05-02 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 789 | WEEK 18,2009 | 2009, 5
417651 | [NAME] | 1 | EA | 939 | SO-5188066 | NLE | 2009-05-02 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 939 | WEEK 18,2009 | 2009, 5
417877 | [NAME] | 1 | EA | 939 | SO-5188283 | JW | 2009-05-04 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 939 | WEEK 19,2009 | 2009, 5
420026 | darrell walker | 1 | EA | 929 | SO-5190291 | NLE | 2009-05-15 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 929 | WEEK 20,2009 | 2009, 5
350543 | [NAME] | 1 | EA | 929 | [NAME] | NLE | 2009-05-18 00:00:00 | [NAME] | 0 | 608.4222 | EXEMPT |  |  | MAIN | 929 | WEEK 21,2009 | 2009, 5
421181 | [NAME] | 1 | EA | 929 | SO-5191316 | KO | 2009-05-20 00:00:00 | [NAME] | 20.000004 | 608.4222 | EXEMPT |  |  | MAIN | 908.999996 | WEEK 21,2009 | 2009, 5
325098 | [NAME] | 1 | EA | 929 | SO-5191739 | JW | 2009-05-22 00:00:00 | [NAME] | 0 | 628.8 | EXEMPT |  |  | MAIN | 929 | WEEK 21,2009 | 2009, 5
421670 | [NAME] | 1 | EA | 929 | SO-5191767 | NLE | 2009-05-22 00:00:00 | [NAME] | 0 | 628.8 | EXEMPT |  |  | MAIN | 929 | WEEK 21,2009 | 2009, 5
422538 | [NAME] | 1 | EA | 929 | SO-5192511 | NLE | 2009-05-25 00:00:00 | [NAME] | 0 | 628.8 | EXEMPT |  |  | MAIN | 929 | WEEK 22,2009 | 2009, 5
424483 | [NAME] | 1 | EA | 929 | SO-5194197 | NLE | 2009-06-02 00:00:00 | [NAME] | 0 | 628.8 | EXEMPT |  |  | MAIN | 929 | WEEK 23,2009 | 2009, 6
424919 | [NAME] | 0 | EA | 829 | SO-5194607 | GT | 2009-06-04 00:00:00 | [NAME] | 0 | 0 | EXEMPT |  |  | MAIN | 829 | WEEK 23,2009 | 2009, 6
421724 | [NAME] | 8 | EA | 835.12 | SO-5195937 | JW | 2009-06-10 00:00:00 | [NAME] | 17.978906 | 5156.16 | EXEMPT |  |  | MAIN | 817.141094 | WEEK 24,2009 | 2009, 6
431311 | [NAME] | 1 | EA | 858 | SO-5200294 | JW | 2009-07-06 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 858.0000000000001 | WEEK 28,2009 | 2009, 7
432242 | [NAME] | 1 | EA | 919 | SO-5201142 | NLE | 2009-07-10 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 28,2009 | 2009, 7
432671 | [NAME] | 1 | EA | 919 | SO-5201425 | NLE | 2009-07-12 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 29,2009 | 2009, 7
432977 | [NAME] | 1 | EA | 919 | SO-5201720 | NLE | 2009-07-14 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 29,2009 | 2009, 7
433356 | [NAME] | 1 | EA | 919 | [NAME] | NLE | 2009-07-16 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 29,2009 | 2009, 7
434710 | [NAME] | 1 | EA | 919 | SO-5203283 | NLE | 2009-07-25 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 30,2009 | 2009, 7
436646 | [NAME] | 1 | EA | 919 | SO-5204930 | NLE | 2009-08-08 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 32,2009 | 2009, 8
436655 | [NAME] | 1 | EA | 919 | SO-5204940 | KO | 2009-08-08 00:00:00 | [NAME] | 0 | 624.87 | EXEMPT |  |  | MAIN | 918.9999999999999 | WEEK 32,2009 | 2009, 8
442910 | [NAME] | 1 | EA | 929 | SO-5210032 | NLE | 2009-09-14 00:00:00 | [NAME] | 0 | 655 | EXEMPT |  |  | MAIN | 929 | WEEK 38,2009 | 2009, 9
442870 | [NAME] | 1 | EA | 929 | SO-5209997 | NLE | 2009-09-14 00:00:00 | [NAME] | 0 | 655 | EXEMPT |  |  | MAIN | 929 | WEEK 38,2009 | 2009, 9
452946 | n/a | 1 | EA | 929 | SO-5218481 | NLE | 2009-10-19 00:00:00 | [NAME] | 0 | 655 | EXEMPT |  |  | MAIN | 929 | WEEK 43,2009 | 2009, 10
475962 | [NAME] | 1 | EA | 929 | SO-5238719 | NLE | 2009-12-23 00:00:00 | [NAME] | 0 | 610 | EXEMPT |  |  | MAIN | 929 | WEEK 52,2009 | 2009, 12
477966 | [NAME] | 1 | EA | 929 | SO-5240562 | NLE | 2009-12-31 00:00:00 | [NAME] | 0 | 655 | EXEMPT |  |  | MAIN | 929 | WEEK 53,2009 | 2009, 12
The ones that are highlighted should pull information because there is a reference to them on sheet1
I am tring to get the total charge in S1 from sheet1