| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Cells That Don't Contain the Following Text Strings
Probably this would be safer, as its not clear if 'honey' or 'cows' could appear within any cell together.
=SUMPRODUCT(N(LEN(SUBSTITUTE(SUBSTITUTE(Fundamenta ls!$B$2:$B$1000,"cows",""),"honey",""))=LEN(Fundam entals!$B$2:$B$1000))) Regards Robert McCurdy "SteveC" wrote in message ... =COUNTIF(Fundamentals!$B$2:$B$1000,OR("<*honey*", "<*cows*")) this doesn't work... any suggestions? thanks very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text cells based on two criteria | Excel Worksheet Functions | |||
| How can I fill a series in Nonadjacent cells eg Text 1, Text 2 | Excel Discussion (Misc queries) | |||
| count cells containing text | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
