| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
countif function
For one cell try this:
A1: Sugar D1: Sugar Plums contain sugar B1: =(LEN(D1)-LEN(SUBSTITUTE(UPPER(D1),UPPER(A1),"")))/LEN(A1) returns 2 For multiple cells: A1: Sugar D1: Sugar Plums contain sugar D2: Sugar and Spice D3: Sugar Bears contain no sugar D4: Candy Apples contain sugar D5: Sugar C1: =SUMPRODUCT(LEN(D1:D10)-LEN(SUBSTITUTE(UPPER(D1:D10),UPPER(A1),"")))/LEN(A1) returns 7 Does that help? €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "nwilson" wrote: can i count how often a word occurs in a cell that has more than one word in the cell??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| COUNTIF and then SUM in Same Function | Excel Worksheet Functions | |||
| A COUNTIF function Challenge | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
