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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif and multiple occurenaces 9
T-shirt Sizes 2
Countif(and 1
Excel function - countif 2
Countifs with different restrictions 1
COUNTIF oddity 1
COUNTIF across worksheets 3
Countif statement using dates 15

Back
Top