Spreadsheet: 141621d1329373374-i-now-need-to-only-sum-the-date-for-this-formular-book2copy
Sheet: Sheet1

Transaction Date | Accounting Date | Work Code | Work Code Description | Category | Transaction Type | Units | Amount | Description | Invoice | [NAME] | Sell Total | Status | Invoice #
2011-12-21 00:00:00 | 2011-12-23 00:00:00 | 20-01-01-0001 | Project Management | LAB | PR cost | 2 | 188 | MOSS; [NAME] |  | 187 | 374 | Assigned | INV-00003
2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 20-01-01-0002 | Project Services | LAB | PR cost | 3 | 516 | LINTON; [NAME] |  | 200 | 600 | Assigned | INV-00003
2011-11-23 00:00:00 | 2011-11-25 00:00:00 | 20-01-01-0001 | Project Management | LAB | PR cost | 2 | 188 | MOSS; [NAME] |  | 187 | 374 | Assigned | INV-00002
2011-11-16 00:00:00 | 2011-11-18 00:00:00 | 20-10-02-0001 | Process Eng - Prelim Design | LAB | PR cost | 1 | 43 | BAHLER; [NAME] |  | 140 | 140 | Assigned | INV-00002
2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 2 | 310 | TAIT; [NAME] |  | 250 | 500 | Assigned | INV-00006
2011-11-07 00:00:00 | 2011-11-11 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 2 | 86 | HO; Emilia |  | 140 | 280 | Assigned | INV-00006
2011-11-07 00:00:00 | 2011-11-11 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 24 | 2256 | PLATON; [NAME] |  | 200 | 4800 | Assigned | INV-00006
2011-11-04 00:00:00 | 2011-11-04 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 0.5 | 21.5 | BAHLER; [NAME] |  | 140 | 70 | Assigned | INV-00006
2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 20-01-01-0002 | Project Services | LAB | PR cost | 2 | 190 | GOLDING; CJ (Bluey) |  | 187 | 374 | Assigned | INV-00002
2011-10-07 00:00:00 | 2011-10-07 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 3 | 282 | MOSS; [NAME] |  | 187 | 561 | Assigned | INV-00001
2011-08-30 00:00:00 | 2011-09-02 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 2 | 202 | BRYANT; [NAME] |  | 200 | 400 | Assigned | INV-00005
2011-08-08 00:00:00 | 2011-08-12 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 1 | 101 | BRYANT; [NAME] |  | 200 | 200 | Assigned | INV-00004
2011-07-31 00:00:00 | 2011-08-05 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 7 | 301 | BAHLER; [NAME] |  | 140 | 980 | Assigned | INV-00004
2011-07-29 00:00:00 | 2011-07-29 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 0.5 | 21.5 | BAHLER; [NAME] |  | 140 | 70 | Assigned | INV-00003
2011-07-21 00:00:00 | 2011-07-22 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 2 | 80 | BAHLER; [NAME] |  | 140 | 280 | Assigned | INV-00003
2011-07-08 00:00:00 | 2011-07-08 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 1 | 40 | BAHLER; [NAME] |  | 140 | 140 | Assigned | INV-00003
2011-07-06 00:00:00 | 2011-07-08 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 8 | 712 | MOSS; [NAME] |  | 187 | 1496 | Assigned | INV-00003
2011-07-05 00:00:00 | 2011-07-08 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 2 | 182 | BRYANT; [NAME] |  | 200 | 400 | Assigned | INV-00003
2011-06-30 00:00:00 | 2011-07-01 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 12 | 1068 | MOSS; [NAME] |  | 187 | 2244 | Assigned | INV-00003
2011-06-27 00:00:00 | 2011-07-01 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 0.5 | 45.5 | BRYANT; [NAME] |  | 200 | 100 | Assigned | INV-00003
2011-06-27 00:00:00 | 2011-07-01 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 2 | 80 | BAHLER; [NAME] |  | 140 | 280 | Assigned | INV-00003
2011-06-20 00:00:00 | 2011-06-24 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 7 | 280 | BAHLER; [NAME] |  | 140 | 980 | Assigned | INV-00002
2011-06-14 00:00:00 | 2011-06-17 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 24 | 960 | BAHLER; [NAME] |  | 140 | 3360 | Assigned | INV-00002
2011-06-14 00:00:00 | 2011-06-17 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 2 | 80 | BAHLER; [NAME] |  | 140 | 280 | Assigned | INV-00002
2011-06-14 00:00:00 | 2011-06-17 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 3.5 | 318.5 | BRYANT; [NAME] |  | 200 | 700 | Assigned | INV-00002
2011-06-06 00:00:00 | 2011-06-10 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 3 | 273 | BRYANT; [NAME] |  | 200 | 600 | Assigned | INV-00002
2011-06-06 00:00:00 | 2011-06-10 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 20.5 | 820 | BAHLER; [NAME] |  | 140 | 2870 | Assigned | INV-00002
2011-06-02 00:00:00 | 2011-06-03 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 8 | 320 | BAHLER; [NAME] |  | 140 | 1120 | Assigned | INV-00002
2011-05-30 00:00:00 | 2011-06-03 00:00:00 | 10-10-02-0002 | Process Eng Capacity Report | LAB | PR cost | 40 | 3760 | LEA; [NAME] |  | 175 | 7000 | WriteOff
2011-05-30 00:00:00 | 2011-06-03 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 21.5 | 860 | BAHLER; [NAME] |  | 140 | 3010 | Assigned | INV-00002
2011-05-30 00:00:00 | 2011-06-03 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 4 | 364 | BRYANT; [NAME] |  | 200 | 800 | Assigned | INV-00002
2011-05-30 00:00:00 | 2011-06-03 00:00:00 | 10-01-01-0010 | Project Services | LAB | PR cost | 4.5 | 400.5 | MOSS; [NAME] |  | 187 | 841.5 | Assigned | INV-00002
2011-05-23 00:00:00 | 2011-05-27 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 33 | 1320 | BAHLER; [NAME] |  | 140 | 4620 | Assigned | INV-00001
2011-05-22 00:00:00 | 2011-05-27 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 4 | 364 | BRYANT; [NAME] |  | 200 | 800 | Assigned | INV-00001
2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 5 | 455 | BRYANT; [NAME] |  | 200 | 1000 | Assigned | INV-00001
2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | -5 | -455 | BRYANT; [NAME] |  | 200 | -1000 | Ignore
2011-05-16 00:00:00 | 2011-05-20 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 5 | 455 | BRYANT; [NAME] |  | 200 | 1000 | Ignore
2011-05-13 00:00:00 | 2011-05-13 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | 10 | 400 | BAHLER; [NAME] |  | 140 | 1400 | Assigned | INV-00001
2011-05-13 00:00:00 | 2011-05-13 00:00:00 | 10-10-02-0001 | Process Eng Report Research | LAB | PR cost | -10 | -400 | BAHLER; [NAME] |  | 140 | -1400 | Ignore
 | sum every month | months ( helper ??) | sumproduct
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 | the date is Column B here  and sum column H |  | the date is Column B here  and sum column H
 | change the range upon specification |  | change the range upon specification