| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=COUNTIF(A1:A1000,"mytext")
-- HTH Bob Phillips "SteW" wrote in message ... Is it possible to get excel to count the cells in a worksheet which contain a text similar to a value? eg If I wanted it to count the number of cells which contains the word "apples", but in some cells it might be spelt "aples" or "appls"? I know in that instance I could just run a spell check, but you get the idea. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| complex fomula: counting cells that are blank | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
| Counting values | Excel Worksheet Functions | |||
Threaded Mode
