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.

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.

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.

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.

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.

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.

Thanks for the website. It's super.

I've been using =SUMPRODUCT which works well however I've tried to copy the
formula into other cells and it's giving me the subsequent cell numbers. I
would like to keep the same cell range from the original cell.

Any suggestions. Maybe the answer is on the website, I will read it soon.

Thanks again

"porter444" wrote:

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.

Look in Excel help for the difference between relative and absolute
addressing.
--
David Biddulph

"Rosebud" wrote in message
...
Thanks for the website. It's super.

I've been using =SUMPRODUCT which works well however I've tried to copy
the
formula into other cells and it's giving me the subsequent cell numbers. I
would like to keep the same cell range from the original cell.

Any suggestions. Maybe the answer is on the website, I will read it soon.

Thanks again

"porter444" wrote:

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.

Hi,

If you show us a sample of the data we can probably provide a better
solution. Without seeing the data layout I suggest using a pivot table.
Very powerful and relatively easy to set up.

Cheers,
Shane Devenshire

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

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