Spreadsheet: 37530d1235569195-help-with-sumif-fuction-please-testdata
Sheet: Sheet1

.
. |  |  |  | Position | Account Manager | [NAME] | Total Opportunity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pull Down List
. |  |  |  | # 01 | [NAME] | 19759 | 66227 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
. |  |  |  | # 02 | [NAME] | 4850 | 2130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liz Macleod/Lorna White |  |  |  |  | Field Sales Manager | Region | Product Line | Month End | Remove | Audited?
. |  |  |  | # 03 | [NAME] | 0 | 12590 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | Scotland | Joints | January | Yes | Yes
. |  |  |  | # 04 | Liz Macleod/Lorna White | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | Northern | Joints | February | Pending discussion | No
. |  |  |  | # 05 | [NAME] | 0 | 4901 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | North West | Joints | March | No
. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Eastern | Joints | May
. | Scotland - Alex Guest |  |  | Total | Scotland | 24609 | 85848 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Des McCluskey | South Thames | Joints | June
. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | North Thames | Joints | July
. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Tue | South West | Joints | August
. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Wales&Severn | Joints | September
. |  |  | Total | 82318 | 3530 |  |  |  |  | 22479 | 0.2075105929269711 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | North | T & E | December
Account Manager | Hospital | Hospital Number | System | PHP Opportunity (€) | Takeout Opportunity (€) (non-PHP) | Permission to [NAME]? Yes / No                        Who |  | Audited? Yes / No | Returned Date | [NAME] | % Returned | Consignment Team Comments | Field Sales Manager & Account Manager Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | North | Spine
[NAME] | [NAME] | 36564 | LCS DD Rot BRG | 2130 |  |  |  |  | 2009-02-02 00:00:00 | 2130 | 0 | Items Identified by PHP Takeout 23-09-08. All found at audit 28/10/08 and not noted to be somewhere other than with all the stock | 13/2/09. [NAME] said [NAME] having trouble finding these. Left meassage with [NAME]
[NAME] | BMI Rosshall | 34729 | All Pfc |  |  |  |  |  | 2009-01-30 00:00:00 | 2078 |  | All [NAME] off consignment
[NAME] | Southern General | 32352 | Global Anchor PEG |  |  |  |  |  | 2009-02-03 00:00:00 | 642
[NAME] | Dr Grays | 39319 | Duraloc liners |  | 3530 |  |  |  |  |  | 0 | at audit 3 sets of liners boxed in stores that hospital said wanted to return JH 2/10/08 | 13/2/09. [NAME] to chase with [NAME]
[NAME] | Dr Grays | 39319 | ELITE PLUS REV STEMS | 1371 |  |  |  |  |  |  | 0 | Items Identified by PHP Takeout 23-09-08 | 13/2/09. Hospital want to keep. [NAME] to audit every 2 months and provide JH with PO to invoice items used |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Field Sales Manager: | [NAME]
[NAME] | IBH [NAME] | 35342 | [NAME] STM | 1188 |  |  |  |  |  |  | 0 | Items Identified by PHP Takeout 23-09-08 | 13/2/09. Can be removed after Cstem (due into hospital 2/3) is being used
[NAME] | Stirling Royal Inf | 61372 | [NAME] Ploy Cup / STR STM | 11402 |  |  |  |  |  |  | 0 | Items Identified by PHP Takeout 23-09-08 | 13/2/09. Can be removed after Cstem (due into hospital 2/3) is being used |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Line: | Joints
[NAME] | Hairmyers | 37647 | Ultima  taper stem | 66227 |  |  |  |  | 2009-02-11 00:00:00 | 892 | 0.0134688269134945 | Product 852781 Items Identified by PHP Takeout 23-09-08. 2 x 852920 returned | 2 years of stock put into hospital to be paid for as used. [NAME] to provide PO to JH
[NAME] | Dumfries & Galloway | 32070 | PFC |  |  |  |  |  | 2009-01-06 00:00:00 | 18152 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month End: | January
[NAME] | Wishaw | 62615 | Pfc size 6 implants |  |  |  |  |  | 28/01/2009 | 715