| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to return a number for how many times a word is used in excel
I am designing a spreadsheet and cannot figure out the formula to return a
number for how many times a word has been used in a range of cells. Please help. |
|
#2
|
|||
|
|||
|
SUMPRODUCT(--ISNUMBER(SEARCH("<word to search for",<range)))
-- David Billigmeier "James Houck" wrote: I am designing a spreadsheet and cannot figure out the formula to return a number for how many times a word has been used in a range of cells. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to word (text) | Excel Discussion (Misc queries) | |||
| How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Linear Mode
