$N$7:$N$28


Gord Dibben MS Excel MVP

On Wed, 26 Nov 2008 13:07:01 -0800, Rosebud
wrote:

This is good however, the text vary e.g., January, February, March through
December. I've tried SUMPRODUCT and it works well. Now I would like to copy
that same formula to other cells and it copies the subsequent cell range.
e.g., N7:N28 changes to N8:N29. Any thoughts on how to keep the same range?


"Gary Mc" wrote:

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.