In the List Of Tickets tab, there is status column, In the Sheet 1 tab there is status which are Cancelled, Closed, Inprog, Queued and Verified. I try to use countif to count how many resolved there are how many inprog there are etc..
The problem I am receiving error message as shown in the photo.
Appreciate your advise.
Thank you in advance.