Using COUNTIF with Multiple Columns & Types of Data

I'm using a tally sheet to analyze Likert scale data. There are multiple groups based on what services people came into our office for (see attachment). In all of the columns in which I used numbers to identify a person's group, I'm able to analyze the data (as shown in the second attachment). The formula I used is:
=COUNTIFS(Workshop,1,Q2a,5)
where "Workshop" is the name of I5:I26 and Q2a is K5:K26 on the tally sheet.

The problem occurs when I try to analyze the "Other" group. I want to identify what the customer came in for, so I've entered text instead of numbers. I nested various combinations of IF and ISTEXT formulas, but nothing worked (e.g., =COUNTIFS(Other,ISTEXT(Other),Q2a,5) or =COUNTIFS(Other,COUNTA(Other),Q2a,5) both of which returned the value of 0 when the answer should be 1). I also tried adding another column of 1's with the specific reason to the right so I could use INDEX or MATCH formulas, but I also couldn't get that to work, nor would entering them as arrays work.

Thanks in advance!
Kayla


Capture.jpgCapture1.JPG

No, unfortunately it doesn't.

I'm not looking in the "Workshop" range for this data, but in the "Other" range, and "Other" isn't an actual word I'm searching for. It could be any number of words.

Thanks though!

I attached images of it in the original post. Capture.jpg shows the tally sheet with the raw data. Capture1.jpg shows how I want the data to be analyzed. It's from the sheet in the workbook titled "Workshops" where I used the formula: =COUNTIFS(Workshop,1,Q2a,5)

Thank you! That works!

What does "<>" search for exactly? Just a cell that is not blank?

Ah, that makes sense. Thanks again! I'm adept at excel, but this data analysis is really stretching me, and I only realize how little I truly know about it.