Spreadsheet: 793044d1661272866-count-the-number-of-times-an-item-doesnt-show-up-in-another-column-data-example
Sheet: Sheet1

Request Date | Part Number | Tracking Number | Notes
2022-07-22 00:00:00 | 67890-SJCA100 | U9RW0725
2022-07-22 00:00:00 | 67890-SJCA100 | U9RW0725
2022-07-25 00:00:00 | 67890-SJCA100 | U9RW0726
2022-07-25 00:00:00 | 67890-SJCA100 | U9RW0726
2022-07-26 00:00:00 | 67890-SJCA100 | U9RW0726
2022-07-26 00:00:00 | 67890-SJCA100 | U9RW0726
2022-07-27 00:00:00 | 12345-SJCA200 | U9RW0727
2022-07-27 00:00:00 | 12345-SJCA200 | U9RW0727
2022-07-27 00:00:00 | 12345-SJCA200 | U9RW0727
2022-07-27 00:00:00 | 12345-SJCA200 | U9RW0727
2022-07-27 00:00:00 | 67890-SJCA100 | U9RW0727 |  |  | How to cound how many times the item listed in COLUMN B does NOT have an entry in COLUMN C.
2022-07-27 00:00:00 | 12345-SJCA200 | U9RW0727
2022-07-29 00:00:00 | 12345-SJCA200 | U9RW0801 |  |  | I was trying to do a COUNTIF/S, but it keeps telling me I have not enough parameters?
2022-07-29 00:00:00 | 12345-SJCA200
2022-07-29 00:00:00 | 12345-SJCA200
2022-07-29 00:00:00 | 12345-SJCA200 |  |  |  | Also, is there a way to keep the "-" in the Part Number?  Or is that causing issues because it thinks it is a minus sign?
2022-07-29 00:00:00 | 12345-SJCA200 | U9RW0801
2022-07-29 00:00:00 | 12345-SJCA200 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 12345-SJCA200 | U9RW0801
2022-07-29 00:00:00 | ABCDE-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801 |  |  | COUNTIF((B2:B68,B73) AND(C2:C68,""))
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801 |  |  | COUNTIF((B2:B68,"67890-SJCA100") AND(C2:C68,""))
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-07-29 00:00:00 | 67890-SJCA100 | U9RW0801
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-04 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-09 00:00:00 | 67890-SJCA100
2022-08-10 00:00:00 | 67890-SJCA100
2022-08-10 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-11 00:00:00 | 67890-SJCA100
2022-08-12 00:00:00 | 67890-SJCA100
2022-08-12 00:00:00 | 67890-SJCA100
2022-08-12 00:00:00 | 67890-SJCA100
2022-08-17 00:00:00 | 67890-SJCA100
2022-08-17 00:00:00 | 67890-SJCA100
2022-08-17 00:00:00 | 67890-SJCA100
2022-08-16 00:00:00 | 12345-SJCA200
2022-08-16 00:00:00 | ABCDE-SJCA100
2022-08-16 00:00:00 | 12345-SJCA100
2022-08-16 00:00:00 | ABCDE-SJCA100
 | Tool 1 | Tool 2 | Tool 3 | Tool 4
 | 67890-SJCA100 | 12345-SJCA200 | ABCDE-SJCA100 | 12345-SJCA100
Backorder |  |  |  |  |  | FORMULA
 | 23 | 4 | 2 | 1 |  | ACTUAL