ExcelBanter - How do I total non-numerical data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I total non-numerical data (https://www.excelbanter.com/new-users-excel/62006-how-do-i-total-non-numerical-data.html)

asg2307

How do I total non-numerical data

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

How do I total non-numerical data

=COUNTIF(A1:A100,"string")

Gord Dibben Excel MVP

On Tue, 27 Dec 2005 10:41:54 -0800, "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?

Gary''s Student

How do I total non-numerical data

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?

All times are GMT +1. The time now is 10:16 AM.