How do I total non-numerical data

[asg2307]

I have data of non-numerical in nature that I want to sort get totals. How
do I do this and report the results?

[Gord Dibben]

=COUNTIF(A1:A100,"string")


Gord Dibben Excel MVP

On Tue, 27 Dec 2005 10:41:54 -0800, "asg2307"
<[email protected]> wrote:

>I have data of non-numerical in nature that I want to sort get totals. How
>do I do this and report the results?

[Gary''s Student]

Use COUNTIF:


If column A has:

dog
dog
cat
cat
cat
fish
fish

then countif(A1:A7,"dog") will give 2, etc.
--
Gary's Student


"asg2307" wrote:

> I have data of non-numerical in nature that I want to sort get totals. How
> do I do this and report the results?