You could use SUMIF; can you post an example of your data?

Also, see this explaination of SUMIF:
http://www.contextures.com/xlFunctions01.html#SumIf
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


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