If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query does not order the same data in the same way | Milković Aleksandar | Running & Setting Up Queries | 10 | December 15th, 2005 12:01 PM |
Microsoft Office should use an advance data crosslinking model | m_jurrens | General Discussions | 0 | December 15th, 2005 07:33 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Having both the date and total of series data displayed underthe data | Jon Peltier | Charts and Charting | 0 | April 14th, 2004 08:39 PM |