Spreadsheet: 135900d1326297803-excel-2007-formula-needed-to-add-up-and-copy-a-lot-of-data-to-separate-tab-in-ss-for-each-month-example-sales-plan-and-funnel-report-2-
Sheet: Sales funnel

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 | SALES PLAN/SALES FUNNEL REPORT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BELOW CELLS ONLY APPLICAPABLE FOR "ORDERS"
 | NO | ID | Status | Customer name | Info updated | Short Description | Branch | Industry/SMA | Customer contact(s) | Sales representative | Business Unit | SP | Service level | Est.value | Number of equipment | Close Date | Probability | Next contact | Next actions | Competitor | Order Month | TRUCARE Contract? | CXT | XN | WLS (Light Crane/Jib) | TRUCARE
 | 1 | 9 |  |  | 20.10.2011 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 6 |  | 0.9 |  |  |  | October | No | 3 | 1 | 1 | 0
 | 2 | 4 |  |  | 13.7.2011 |  |  |  |  |  | CSER | SP21C (SL4) | SL1 |  |  |  | 0.5
 | 3 | 4 |  |  | 01.8.2011 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 1 |  | 0.8
 | 4 | 2 |  |  | 13.7.2011 |  |  |  |  |  | CSER | SP21B (SL3) | SL3 |  | 2
 | 5 | 4 |  |  | 16.12.11 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 55 |  | 0.6 | 27.9.2011
 | 6 | 4 |  |  | 13.7.2011 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 13 |  | 0.3
 | 7 | 5 |  |  | 28.10.11 |  |  |  |  |  | CSER | SP21C (SL4) | SL3 |  | 45 |  | 0.5
 | 8 | 3 |  |  | 13.7.2011 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 1
 | 9 | 9 |  |  | 11.01.2012 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 2 |  | 0.8 | 28.9.2011
 | 10 | 4 |  |  | 01.11.11 |  |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 5
 | 11 | 4 |  |  | 23.8.2011 |  |  |  |  |  | CSER | SP27 | SL3 |  | 1
 | 12 | 2 |  |  | 13.7.2011 |  |  |  |  |  | CSER | SP27 | SL3
 | 13 | 2 |  |  | 9.09.2011 |  |  |  |  |  | CSER | SP27 | SL3
 | 14 | 4 |  |  | 01.8.2011 |  |  |  |  |  | CSER | SP27 | SL1
 | 15 | 4 |  |  | 01.8.2011 |  |  |  |  |  | CSER | SP27 | SL1
 | 16 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 17 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 18 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 19 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 20 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 21 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 22 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 23 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 24 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 25 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 26 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 27 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 28 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 29 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 30 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 31 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 32 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 33 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 34 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 35 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 36 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 37 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 38 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 39 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 40 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 41 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 42 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 43 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 44 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 45 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 46 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 47 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 48 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 49 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 50 | 3 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 51 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 52 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 53 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 54 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 55 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 56 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 57 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 58 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 59 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 60 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 61 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 62 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 63 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 64 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 65 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 66 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 67 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 68 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 69 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 70 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 71 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 72 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 73 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 74 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 75 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 76 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 77 | 4 |  |  | 23.9.2011 | New contract |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 13
 | 78 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 79 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 80 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 81 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 82 | 0 |  |  | 13.7.2011 |  |  |  |  |  |  |  | SL1
 | 83 | 4 |  |  | 23.8.2011 | Hoist |  |  |  |  | CSER | SP26 | SL3 |  | 2 |  | 0.5
 | 84 | 0 |  |  | 21.7.2011 | new Contract - New Crane |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 85 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 86 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 87 | 2 |  |  | 02.11.11 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 88 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 89 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 90 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 91 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 92 | 0 |  |  | 21.7.2011 | Cancelled Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 93 | 2 |  |  | 01.8.2011 | New contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 94 | 4 |  |  | 01.8.2011 | New Contract |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 64 |  | 0.3
 | 95 | 3 |  |  | 05.8.2011 | Hoist |  |  |  |  | CSER | SP26 | SL3
 | 96 | 5 |  |  | 01.11.11 | [NAME] |  |  |  |  | CSER | SP26 | SL1 |  | 3 |  | 0.6
 | 97 | 4 |  |  | 22.8.2011 | Radio Controls |  |  |  |  | CSER | SP22m | SL3 |  | 20 |  | 0.8
 | 98 | 4 |  |  | 15.8.2011 | New Hoist |  |  |  |  | CSER | SP26 | SL1 |  | 1 |  | 0.5
 | 99 | 1 |  |  | 15.8.2011 | RailQ |  |  |  |  | CSER | SP29C | SL3
 | 100 | 4 |  |  | 15.8.2011 | RailQ |  |  |  |  | CSER | SP29C | SL1
 | 101 | 4 |  |  | 15.8.2011 | RailQ |  |  |  |  | CSER | SP29C | SL3
 | 102 | 4 |  |  | 15.8.2011 | RailQ |  |  |  |  | CSER | SP29C | SL1
 | 103 | 4 |  |  | 30.9.2011 | New Contract |  |  |  |  | CSER | SP21B (SL3) | SL3 |  | 2 |  | 0.8
 | 104 | 4 |  |  | 17.8.2011 | New Contract |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 4 |  | 0.8
 | 105 | 4 |  |  | 18.8.2011 | New 5t CXT |  |  |  |  | CSER | SP26 | SL3 |  |  |  | 0.7
 | 106 | 3 |  |  | 15.12.2011 | Trucare Offer |  |  |  |  | CSER | SP21C (SL4) | SL3 |  | 5 |  | 0.6
 | 107 | 4 |  |  | 09.9.2011 | 2 new hoists |  |  |  |  | CSER | SP26 | SL1 |  | 2 |  | 0.7
 | 108 | 2 |  |  | 06.9.2011 | Level 4 Contract |  |  |  |  | CSER | SP21C (SL4) | SL3
 | 109 | 4 |  |  | 23.9.2011 | CRS on Waste Grab Crane |  |  |  |  | CSER | SP29B | SL3
 | 110 | 4 |  |  | 23.9.2011 | RailQ |  |  |  |  | CSER | SP29C | SL1
 | 111 | 3 |  |  | 28.9.2011 | Replace Crab Unit |  |  |  |  | CSER | SP26 | SL1
 | 112 | 4 |  |  | 14.9.2011 | CRS on PM1 Dry End Crane |  |  |  |  | CSER | SP29B | SL4
 | 113 | 5 |  |  | 08.11.11 | Addition to Contract |  |  |  |  | CSER | SP21C (SL4) | SL4
 | 114 | 3 |  |  | 06.10.11 | Addition to Contract |  |  |  |  | CSER | SP21B (SL3) | SL3
 | 115 | 5 |  |  | 31.10.11 | New 5t CXT |  |  |  |  | CSER | SP26 | SL3
 | 116 | 3 |  |  | 28.9.2011 | New Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 117 | 2 |  |  | 27.9.2011 | New Contract |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 118 | 4 |  |  | 13.10.11 | New Crab Unit |  |  |  |  | CSER | SP26 | SL1
 | 119 | 2 | Opportunity |  | 03.01.12 | CRS |  |  |  |  | CSER | SP29C | SL3
 | 120 | 4 |  |  | 31.10.11 | CXT30410032P25FC |  |  |  |  | CSER | SP26 | SL3
 | 121 | 4 |  |  | 01.11.11 | XN Chain Hoist |  |  |  |  | CSER | SP26 | SL1
 | 122 | 2 |  |  | 02.11.11 | Sp21 - New Crane |  |  |  |  | CSER | SP21B (SL3) | SL1
 | 123 | 3 |  |  | 02.11.11 | CXTEX |  |  |  |  | CSER | SP26 | SL1
 | 124 | 4 |  |  | 09.11.11 | New Sp21 |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 1 | 2011-12-23 00:00:00 | 0.6
 | 125 | 4 |  |  | 09.11.11 | New CXT |  |  |  |  | CSER | SP26 | SL3
 | 126 | 3 | Qualified opportunity |  | 15.12.11 | Trucare Offer |  |  |  |  | CSER | SP21C (SL4) | SL1 |  | 4
 | 127 | 4 |  |  | 19.12.11 | SL3 Contract |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 4
 | 128 | 4 |  |  | 14.12.11 | SL3 Contract |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 31 |  | 0.2
 | 129 | 4 |  |  | 29.12.11 | 3t EWRH |  |  |  |  | CSER | SP26 | SL1 |  | 1 |  |  |  |  | NOR CRANE
 | 130 | 9 |  |  | 05.01.2012 | HCB and [NAME] |  |  |  |  | CSER | SP26 | SL1 |  | 1 |  | 0.8
 | 131 | 2 |  |  | 22.12.11 | Trucare Offer |  |  |  |  | CSER | SP21C (SL4) | SL1
 | 132 | 4 |  |  | 03.01.12 | [NAME] |  |  |  |  | CSER | SP21C (SL4) | SL4 |  | 92 |  | 0.8
 | 133 | 3 |  |  | 03.01.12 | Sp21 - Level 3 |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 14
 | 134 | 3 |  |  | 06.01.12 | Sp21 - Level 3 |  |  |  |  | CSER | SP21B (SL3) | SL1 |  | 4
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 9