Countif and Multiple occurances

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell that has three enteries in it based on shirt size when i use
countif it only counts one is there a way to make it or use something else to
count all. Here is the data:

A1: yl,yl,yl B1 Countif(a1,"*yl*") - this only returns one. if I do not use
the wild cards I get none. I want b1 to have 3 in it. By the way A1: can
also have ys,yl,ym in it and each one of them should only count as one not
three.
Thanks
 
If the text you are searching for is in, say, cell C1

=(LEN(A1)-LEN(SUBSTITUTE(A1,C1,"")))/LEN(C1)
 
That works for one cell but how do you sum all in a range do I have to have a
seperate column and then sum it?
 
Hi
my formula with Sumproduct should work

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
 
Back
Top