| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells containing text values in Excell
I am trying to count the cells in a given range containing a certain text
value in an Excel 2000 spreadsheet. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count cells containing text values in Excell
One way:
=COUNTIF(given_range, "certain_text_value") In article , Ross Stanton <Ross wrote: I am trying to count the cells in a given range containing a certain text value in an Excel 2000 spreadsheet. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count cells containing text values in Excell
This will count of cells containing "ABC"
=COUNTIF(A1:A10,"ABC") This count cells where text contains ABC within it e.g. ABCDEF would be counted. =COUNTIF(A2:A10,"*ABC*") HTH "Ross Stanton" wrote: I am trying to count the cells in a given range containing a certain text value in an Excel 2000 spreadsheet. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT SEVERAL TEXT VALUES AUTOMATICALLY | Excel Worksheet Functions | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
| using =COUNTIF to count two text values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count bold text values | Excel Worksheet Functions | |||
Linear Mode
