Conditional formatting for text to number

I am needing some help with the best way to quatify text.
Here is what I have. I am wanting to be able to a chart that will count how
many of each town. Rather than manually counting how many of each, I would
like to have it programed to do that for me

Name Town
Bill Breese
John Chicago
Tony Breese


I would like to have it count each different town and place that number in a
different cell to total.

Thanks in advanced

Jason

Set the following formula in cells, using each different Town in each one.
This will give numbers for each town. You can then build your chart from
those cell values.

I am assuming the Name is one column and the Town is another.

=COUNTIF(B2:B100,"Breese")
--
Best wishes,

Jim


"Jason" wrote:

> I am needing some help with the best way to quatify text.
> Here is what I have. I am wanting to be able to a chart that will count how
> many of each town. Rather than manually counting how many of each, I would
> like to have it programed to do that for me
>
> Name Town
> Bill Breese
> John Chicago
> Tony Breese
>
>
> I would like to have it count each different town and place that number in a
> different cell to total.
>
> Thanks in advanced
>
> Jason

A pivot table is probably the easiest way to do this
(select the Town column, then Data/Pivot Table..)

Jason wrote:
> I am needing some help with the best way to quatify text.
> Here is what I have. I am wanting to be able to a chart that will count how
> many of each town. Rather than manually counting how many of each, I would
> like to have it programed to do that for me
>
> Name Town
> Bill Breese
> John Chicago
> Tony Breese
>
>
> I would like to have it count each different town and place that number in a
> different cell to total.
>
> Thanks in advanced
>
> Jason

See below for what you need to use:

From the help file:

COUNTA

Counts the number of cells that are not empty and the values within the list
of arguments. Use COUNTA to count the number of cells that contain data in a
range or array.

Syntax

COUNTA(value1,value2,...)

Value1, value2, ... are 1 to 30 arguments representing the values you want
to count.



"Jason" wrote:

> I am needing some help with the best way to quatify text.
> Here is what I have. I am wanting to be able to a chart that will count how
> many of each town. Rather than manually counting how many of each, I would
> like to have it programed to do that for me
>
> Name Town
> Bill Breese
> John Chicago
> Tony Breese
>
>
> I would like to have it count each different town and place that number in a
> different cell to total.
>
> Thanks in advanced
>
> Jason

Thanks for the input. I will try it over the weekend.

Jason

"Jason" wrote:

> I am needing some help with the best way to quatify text.
> Here is what I have. I am wanting to be able to a chart that will count how
> many of each town. Rather than manually counting how many of each, I would
> like to have it programed to do that for me
>
> Name Town
> Bill Breese
> John Chicago
> Tony Breese
>
>
> I would like to have it count each different town and place that number in a
> different cell to total.
>
> Thanks in advanced
>
> Jason

Hi Jason,

How is the things going?
Did you have any finding after you perform the testing?

If you have any questions or concerns, please don't hesitate to let me
know. I look forward to hearing from you, and I am happy to be of
assistance.


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.