Excel question--counting words in a cell

Help please – suppose I have 5 cells with the following: soppinuppalnumi nuppal soppinumi numinuppal soppi and I wanted to count the number of times the string “soppi” shows up in those 5 cells, is there a formula that can do that for me? The count should be 3.

Can the string appear more than once in any cell? If not, you can do it easily using SUMIF(), ISERROR() and FIND().

No it won’t appear more than once in any cell. Can you show how you would use those functions? I keep trying variations of countif() with &'s and can’t get it work.

Ok, here is the easiest way I can think of to do this. If the first cell in your data is A1, then add a column directly to the right of your data with these formulas: =IF(ISERROR(FIND(“soppi”,A1,1)),0,1) =IF(ISERROR(FIND(“soppi”,A2,1)),0,1) etc. Then sum the second column.


1morelevel Wrote: ------------------------------------------------------- > http://support.microsoft.com/kb/213889 Sweet, this one worked, thanks man.

I feel honored to be in the same cell as Numi and Soppi, Smirky, you dont wanna jump into to this brofest?