Spreadsheet: 83914d1283951059-finding-counting-and-summing-multiple-variables-in-a-data-table-spreadsheet-sample
Sheet: Sheet1

Start Date Priority | Company | Quote # | MO # | Quoted Date | [NAME] # | Sales Date | Total Days to Completed Quote | Quote to Sales Turn Over Time
2010-06-16 00:00:00 | NEW PRODUCTION SCHEDULE
2010-06-16 00:00:00 | X Company | 5165 |  | 2010-06-22 00:00:00 | 4478
2010-06-16 00:00:00 | Y Company | 5172 |  | 2010-07-15 00:00:00
2010-06-22 00:00:00 | Z Company | 5173 |  | 2010-06-22 00:00:00 | 4506
2010-06-14 00:00:00 | Z Company | 5174 |  | 2010-06-29 00:00:00
2010-06-23 00:00:00 | L Company | 5175 |  | 2010-06-23 00:00:00
2010-06-24 00:00:00 | A Company | 5176 |  | 2010-07-02 00:00:00
2010-06-24 00:00:00 | X Company | 5177
2010-06-26 00:00:00 | Y Company | 5171 | 4104
2010-06-29 00:00:00 | Z Company | 5181 |  | 2010-07-09 00:00:00
2010-06-30 00:00:00 | Z Company | 5182 |  | 2010-07-09 00:00:00 | 4586 | 2010-08-10 00:00:00
2010-07-01 00:00:00 | L Company | 5183 |  | 2010-07-07 00:00:00
2010-07-06 00:00:00 | A Company | 5184 |  | 2010-07-13 00:00:00
2010-07-06 00:00:00 | X Company | 5185 | 4110 | 2010-08-17 00:00:00
2010-07-07 00:00:00 | Y Company | 5186 |  | 2010-07-08 00:00:00 | 4603 | 2010-08-24 00:00:00
2010-07-09 00:00:00 | Z Company | 5187 |  | 2010-07-14 00:00:00
2010-07-12 00:00:00 | Z Company | 5189 |  | 2010-08-02 00:00:00
2010-07-12 00:00:00 | L Company | 5190 | 4111 | 2010-08-10 00:00:00
2010-07-12 00:00:00 | A Company | 5191 |  | 2010-07-20 00:00:00 | 4546-48
2010-07-12 00:00:00 | X Company | 5192 |  | 2010-07-20 00:00:00 | 4561
2010-07-14 00:00:00 | Y Company | 5193 |  | 2010-07-17 00:00:00 | 4537
2010-07-16 00:00:00 | Z Company | 5194 | 4103 | 2010-07-16 00:00:00
2010-07-19 00:00:00 | Z Company | 5195 | 4109 | 2010-07-23 00:00:00 | 4560
2010-07-22 00:00:00 | L Company | 5197 | 4112 | 2010-07-26 00:00:00 | 4550
2010-07-22 00:00:00 | A Company | 5198
2010-07-22 00:00:00 | X Company | 5199 | 4095 | 2010-08-03 00:00:00 | 4585 | 2010-08-10 00:00:00
2010-07-22 00:00:00 | Y Company | 5200 | 4117 | 2010-08-20 00:00:00
2010-07-22 00:00:00 | Z Company | 5201
2010-07-23 00:00:00 | Z Company | 5202 | 4114 | 2010-08-03 00:00:00 | 4566 | 2010-08-04 00:00:00
2010-07-23 00:00:00 | L Company | 5203 | 4124 | 2010-08-23 00:00:00
2010-07-27 00:00:00 | A Company | 5204 | 4113 | 2010-08-03 00:00:00 | 4584 | 2010-08-10 00:00:00
2010-07-27 00:00:00 | X Company | 5205 | 4121
2010-07-28 00:00:00 | Y Company | 5206 | 4120 | 2010-08-25 00:00:00
2010-08-03 00:00:00 | Z Company | 5208 | 4115 | 2010-08-04 00:00:00
2010-08-03 00:00:00 | Z Company | 5209 | 4116 | 2010-08-04 00:00:00
2010-08-04 00:00:00 | L Company | 5210
2010-08-04 00:00:00 | A Company | 5211 | 4118 | 2010-08-30 00:00:00
2010-08-04 00:00:00 | X Company | 5212 | 4119 | 2010-08-09 00:00:00
2010-08-06 00:00:00 | Y Company | 5213 | NA | 2010-08-09 00:00:00 | 4583 | 2010-08-09 00:00:00
2010-08-06 00:00:00 | Z Company | 5214 | 4129
2010-08-11 00:00:00 | Z Company | 5216 | 4126 | 2010-08-30 00:00:00
2010-08-12 00:00:00 | L Company | 5217 | NA | 2010-08-18 00:00:00
2010-08-17 00:00:00 | A Company | 5218 | NA | 2010-08-17 00:00:00 | 4613 | 2010-08-26 00:00:00
2010-08-18 00:00:00 | X Company | 5219 | 4127 | 2010-09-07 00:00:00
2010-08-20 00:00:00 | Y Company | 5220 | NA | 2010-08-25 00:00:00
2010-08-20 00:00:00 | Z Company | 5221 | NA | 2010-08-20 00:00:00 | 4599 | 2010-08-20 00:00:00
2010-08-23 00:00:00 | Z Company | 5222 | NA | 2010-08-23 00:00:00 | 4602 | 2010-08-23 00:00:00
2010-08-25 00:00:00 | L Company | 5223 | 4125 | 2010-08-30 00:00:00
2010-08-25 00:00:00 | A Company | 5224 | NA | 2010-08-25 00:00:00 | 4605 | 2010-08-25 00:00:00
2010-08-25 00:00:00 | X Company | 5225
2010-08-25 00:00:00 | Y Company | 5226 | 4128 | 2010-08-30 00:00:00
2010-08-25 00:00:00 | Z Company | 5227 |  | 2010-08-30 00:00:00 | 4627 | 2010-09-07 00:00:00
2010-08-25 00:00:00 | Z Company | 5228 |  | 2010-08-25 00:00:00
2010-08-26 00:00:00 | L Company | 5229
2010-08-30 00:00:00 | A Company | 5231 | NA | 2010-08-30 00:00:00
2010-08-30 00:00:00 | X Company | 5232 | 4131
2010-08-30 00:00:00 | Y Company | 5233 | 4132
2010-08-30 00:00:00 | Z Company | 5234 | NA | 2010-08-30 00:00:00 | 4615
2010-08-30 00:00:00 | Z Company | 5236 | 4130 | 2010-09-03 00:00:00 | 4625 | 2010-09-03 00:00:00
2010-08-31 00:00:00 | L Company | 5237 |  | 2010-08-31 00:00:00
2010-08-31 00:00:00 | A Company | 5238 | NA | 2010-08-31 00:00:00 | 4617 | 2010-08-31 00:00:00
2010-08-31 00:00:00 | X Company | 5239 | NA | 2010-08-31 00:00:00 | 4620 | 2010-09-01 00:00:00
2010-09-01 00:00:00 | Y Company | 5241 | NA | 2010-09-01 00:00:00 | 4621 | 2010-09-01 00:00:00
2010-09-01 00:00:00 | Z Company | 5240 | NA | 2010-09-01 00:00:00 | 4622 | 2010-09-01 00:00:00
2010-09-02 00:00:00 | Z Company | 5242 | NA | 2010-09-02 00:00:00 | 4623 | 2010-09-02 00:00:00
2010-09-02 00:00:00 | L Company | 5243 | NA | 2010-09-02 00:00:00 | 4624 | 2010-09-02 00:00:00
2010-09-03 00:00:00 | A Company | 5244 | 4133 | 2010-09-07 00:00:00
2010-09-07 00:00:00 | X Company | 5245
2010-09-07 00:00:00 | Y Company | 5246 |  | 2010-09-07 00:00:00
2010-09-07 00:00:00 | Z Company | 5247
2010-09-07 00:00:00 | Z Company | 5248 |  | 2010-09-07 00:00:00 | 4629 | 2010-09-07 00:00:00