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