| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count If query within string
Hi all,
I am trying to count a word within a range of cells. Some cells may contain the word within a text string for example: Count the word "red" within "red 1", "red 2", "red 3" etc. I know this can be done with the formula..."=CountIf(range, "*red*")" The real question is if this is possible to search by a cell value? ie. If cell "A1" equals "red" then count "red", if "A1" equals "blue" then count the number of times "blue" appears. Hope this makes sense. Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count If query within string
=COUNTIF(range,"*"&A1&"*")
-- __________________________________ HTH Bob "JohnH" wrote in message ... Hi all, I am trying to count a word within a range of cells. Some cells may contain the word within a text string for example: Count the word "red" within "red 1", "red 2", "red 3" etc. I know this can be done with the formula..."=CountIf(range, "*red*")" The real question is if this is possible to search by a cell value? ie. If cell "A1" equals "red" then count "red", if "A1" equals "blue" then count the number of times "blue" appears. Hope this makes sense. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing Query String into MS Excel | Excel Discussion (Misc queries) | |||
| Get Query String from Access | Excel Programming | |||
| MS Query DateTime String | Excel Worksheet Functions | |||
| Querying 2 databases with one query string | Excel Discussion (Misc queries) | |||
| Syntax for ADO Query String | Excel Programming | |||
Linear Mode
