Not able to fix Zero-length String in Formula

Hi, I'm using a formula that is trying to calculate the total number of items (or tickets) using COUNTIFS from a table based on 3 different criteria. However, the criteria for column W which is look...