Use =COUNTIF(RANGE,"CLOSED") or whatever your text is.

"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.