G Guest Dec 27, 2005 #1 I have data of non-numerical in nature that I want to sort get totals. How do I do this and report the results?
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 Guest Dec 27, 2005 #3 Use COUNTIF: If column A has: dog dog cat cat cat fish fish then countif(A1:A7,"dog") will give 2, etc.
Use COUNTIF: If column A has: dog dog cat cat cat fish fish then countif(A1:A7,"dog") will give 2, etc.
