Spreadsheet: 55565d1255680925-formula-to-count-multiple-ifs-and-take-an-average-703475_sam_d_v2
Sheet: Sheet1

Item No. | Company | Query Raised | Query Arrived | Number of Rejections | COMMENTS | Added to internal system F | Answered and sent back to Company G | Company Internal Lag H (D-C) | Overal Company Lag Time Due to Query Deficencies I (F-C) | Lag Time Per Rejection J ((F-D)/E) | Process Time K (G-F)
1 | Company A | 2009-05-21 00:00:00 | 2009-07-01 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 41 | 53 | 12 | 7
2 | Company B | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 0 |  | 2009-05-27 00:00:00 | 2009-06-02 00:00:00 | 1 | 1 | 0 | 6
3 | Company A | 2009-06-15 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-13 00:00:00 | 15 | 15 | 0 | 13
4 | Company A | 2009-06-16 00:00:00 | 2009-07-09 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 23 | 27 | 4 | 7
5 | Company A | 2009-06-17 00:00:00 | 2009-07-14 00:00:00 | 1 |  | 2009-07-14 00:00:00 | 2009-07-20 00:00:00 | 27 | 27 | 0 | 6
6 | Company A | 2009-06-18 00:00:00 | 2009-07-01 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 13 | 25 | 12 | 7
7 | Company C | 2009-06-24 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-09 00:00:00 | 6 | 6 | 0 | 9
8 | Company C | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-08 00:00:00 | 0 | 0 | 0 | 8
9 | Company C | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 0 |  | 2009-07-01 00:00:00 | 2009-07-13 00:00:00 | 1 | 1 | 0 | 12
10 | Company A | 2009-07-01 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 8 | 12 | 0 | 7
11 | Company B | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 0 |  | 2009-07-02 00:00:00 | 2009-07-08 00:00:00 | 1 | 1 | 0 | 6
12 | Company A | 2009-07-04 00:00:00 | 2009-07-09 00:00:00 | 2 |  | 2009-07-17 00:00:00 | 2009-07-27 00:00:00 | 5 | 13 | 4 | 10
13 | Company C | 2009-07-08 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-09 00:00:00 | 2009-07-16 00:00:00 | 1 | 1 | 0 | 7
14 | Company A | 2009-07-09 00:00:00 | 2009-07-28 00:00:00 | 1 | Lack of corrective action | 2009-07-30 00:00:00 | 2009-09-02 00:00:00 | 19 | 21 | 2 | 34
15 | Company C | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-09 00:00:00 | 2009-07-14 00:00:00 | 0 | 0 | 0 | 5
16 | Company B | 2009-07-10 00:00:00 | 2009-07-10 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-14 00:00:00 | 0 | 3 | 3 | 1
17 | Company A | 2009-07-14 00:00:00 | 2009-08-07 00:00:00 | 0 |  | 2009-08-10 00:00:00 | 2009-08-13 00:00:00 | 24 | 27 | 0 | 3
18 | Company C | 2009-07-15 00:00:00 | 2009-07-15 00:00:00 | 0 |  | 2009-07-16 00:00:00 | 2009-07-23 00:00:00 | 0 | 1 | 0 | 7
19 | Company A | 2009-07-16 00:00:00 | 2009-08-05 00:00:00 | 0 |  | 2009-08-05 00:00:00 | 2009-08-05 00:00:00 | 20 | 20 | 0 | 0
20 | Company B | 2009-07-16 00:00:00 | 2009-07-17 00:00:00 | 1 |  | 2009-07-17 00:00:00 | 2009-07-22 00:00:00 | 1 | 1 | 0 | 5
21 | Company C | 2009-07-16 00:00:00 | 2009-07-27 00:00:00 | 1 | To be Concession not Prod Per | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 | 11 | 12 | 1 | 0
22 | Company A | 2009-07-23 00:00:00 | 2009-07-29 00:00:00 | 1 | Lack of corrective action | 2009-07-30 00:00:00 | 2009-09-02 00:00:00 | 6 | 7 | 1 | 34
23 | Company C | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-29 00:00:00 | 1 | 4 | 0 | 2
24 | Company C | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-29 00:00:00 | 1 | 4 | 0 | 2
25 | Company A | 2009-07-24 00:00:00 | 2009-09-24 00:00:00 | 1 | Centre positions req'd, centre line, instl pos'ns. | 2009-09-30 00:00:00 | 2009-10-12 00:00:00 | 62 | 68 | 6 | 12
26 | Company C | 2009-07-24 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-31 00:00:00 | 0 | 3 | 0 | 4
27 | Company C | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 | 0 |  | 2009-08-04 00:00:00 | 2009-08-05 00:00:00 | 0 | 7 | 0 | 1
28 | Company A | 2009-07-29 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2 | 2 | 0 | 0
29 | Company A | 2009-07-29 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-08-04 00:00:00 | 2 | 2 | 0 | 4
30 | Company A | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-08-04 00:00:00 | 0 | 0 | 0 | 4