| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
Hybrid Mode
