I've used "countif" using one column and it works well. I run into difficulty
when I try to combine another column with varying text.

"Russell Hampton" wrote:

I have a similar project and I use COUNTIF. I allow the variable to be the
text. The only problem that I have found is consistency. If the text is
misspelled then it won't count it.

"Rosebud" wrote:

I have created a worksheet with columns to count the number of tickets
assigned to staff and would like to calculate the number of tickets closed
each month by each employee.

Does anyone know how to count the totals of tickets when the cells consist
of text?

Thanks for any help offered.