How do I total non-numerical data

A

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?
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Copy addition formula of non-consecutive horizontal cells 2
Incone & Expenses Statement 0
Outlook 365 overriding formatting choices 0
Filtering data from a non-continuous list 3
Pivot table 0
Non Commercial Use 3
Data conversion: Text to Numeric to Support Averaging 1

Top