How would I be able to see how mwny times a certain word is in a cell, for
example in cell A1 is the text milk bread milk, how can I know that there is
2 times the word milk in the cell?

"Toppers" wrote:

If there can be mulfiple occurences of "F" in ONE cell e.g cell contains "PPF
F PPF" i.e this counts as 3, then try:

=SUMPRODUCT(LEN(P6:P31)-LEN(SUBSTITUTE(P6:P31,"F","")))

If a cell only ever contains ONE "F" then your formula should work: it did
for me.

HTH

"Pinkgoldfish" wrote:

Hello,

I had the same issue as "holliedavis", where I am trying to count multiple
occurrences within single cells. However, my trouble is that for some reason
I am not getting the correct number! I can see that the correct answer is 7
occurrences of "F", but the formula tells me there are only 4 occurrences. I
must be missing something, because with count I'm trying to do it is correct.
I am using the formula:
=SUMPRODUCT(--ISNUMBER(SEARCH("F",P6:P31)))

A sample cell might be "PPF", blank, or just "F"

Thanks!



"Toppers" wrote:

Try:

=SUMPRODUCT(--ISNUMBER(SEARCH("22087",A1:B100)))

HTH

"holliedavis" wrote:

I need to identify the correct function to achieve the following task:
Search specified column to find "22087", and count the occurences.

The problem I am having is that the cells within this column often contain
more than one numeric value in each cell. For example, contents of one
single cell may look like this: 22087, 22058, 22064. This cell identifies
the locations of all the jobs a candidate is willing to consider. If a
candidate is willing to consider placement in multiple cities/states, they
are all listed within the cell.
I need to know how many candidates are applying for each location #, and
CountIF only seems to work if the cells contain only one value. Help?