Spreadsheet: 855604d1705119000-countif-if-one-of-two-column-have-value-late-sample1
Sheet: DECEMBER

 |  |  |  |  |  |  |  |  |  |  |  |  | TYPE COUNT | QUANTITY | Repeats |  | QPRS ISSUED | QPRs NO RESPONSE | QPRs W/ FULL STCM | QPRs LATE | QPRs LTCM PLAN | QPRs AWAITING SAI | QPRs CLOSED
 |  |  |  |  |  |  |  |  |  |  |  | Foam
 |  |  |  |  |  |  |  |  |  |  |  | Frame
 |  |  |  |  |  |  |  |  |  |  |  | Kitting
 |  |  |  |  |  |  |  |  |  |  |  | Plastic
 |  |  |  |  |  |  |  |  |  |  |  | Trim Cover
 |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  | QPR's ISSUED TO TBMS |  |  |  |  |  |  |  |  | 2022 068D DECEMBER SUPPLIER QPR TRACKING LOG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CANCELLED
 |  |  |  |  |  | ISSUANCE |  |  |  |  |  |  |  |  |  |  |  | STCM ACTIVITY |  |  |  | LTCM ACTIVITY |  |  |  |  |  |  |  |  |  | QPR STATUS |  | OCCURRENCE
 |  |  |  |  |  |  |  |  | S,A,B,C |  | Y/N |  |  |  |  |  |  |  |  |  |  | SKPI/QPR |  |  |  |  |  |  | ON TIME | LATE | NOTE ITEMS | APPROVE/REJECT |  | AFTER LCTM?
 | TYPE COUNT | QUANTITY | Repeats |  | # | INITIAL RELEASE | OFFICIAL DATE ISSUED | QPR # | RANK | QUANTITY | REPEAT ISSUANCE | PART NAME | TYPE | SUPPLIER | DEFECT CODE | DEFECT DESCRIPTION | SHORT DUE DATE | STCM CLEAN POINT # | SHORT TERM C/M | STCM RECEIVED DATE | STCM ON TIME/LATE | LTCM DUE DATE | LTCM PLAN SUBMITTED | LTCM PLAN ACCEPTED DATE | LTCM PLAN REJECTED DATE | LTCM ACTUAL SUBMITTED | LTCM ACTUAL ACCEPTED DATE | LTCM ACTUAL REJECTED DATE | QPR CONDITION | LTCM ON TIME | COMMENTS | STATUS | 90 DAY CM VERIFICATION | REVISIONS | MONTH
Foam |  |  |  |  | 1 | 2023-10-05 00:00:00 |  |  |  | 3 | Y |  | Foam |  |  |  | 2023-10-05 00:00:00 |  |  | 2023-10-04 00:00:00 | LATE | 2023-10-28 00:00:00 |  | 2024-10-27 00:00:00 |  |  |  |  | 0 | LATE
Frame |  |  |  |  | 2 | 2024-10-05 00:00:00 |  |  |  | 4 | Y |  | Foam |  |  |  | 2024-10-05 00:00:00 |  |  | 2024-10-05 00:00:00 | LATE
Kitting |  |  |  |  | 3
Plastic |  |  |  |  | 4
Trim Cover |  |  |  |  | 5
Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Foam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frame
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kitting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trim Cover