Questions???

[Rosebud]

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.

 

[porter444]

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

 

[Gary Mc]

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

 

[Rosebud]

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.

 

[Rosebud]

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?

 

[Rosebud]

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

 

[David Biddulph]

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

 

[Shane Devenshire]

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

 

[Gord Dibben]

$N$7:$N$28


Gord Dibben MS Excel MVP

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?