Can you use CountA to add multiple items within one cell?

  • Thread starter Teacher in a quandry
  • Start date
T

Teacher in a quandry

I need to be able to count items in a column, but also have it add multiple
items with in one cell. Any ideas?
 
B

Bernard Liengme

=COUNTA(A1:A100),"A")+COUNTA(A1:A100,"B")
to count how many As and Bs in the range ?
Or is the question something else?
best wishes
 
J

JMB

Your details are a little vague, but something like this would count the
number of "j"'s and "f"'s that occur in C5:C6

=SUMPRODUCT(LEN(C5:C6)-LEN(SUBSTITUTE(C5:C6,{"j","f"},"")))

so if you had
jeff
joe

you would get 3. If you don't get a solution that works for you, perhaps an
example of your data and expected results may help.
 
J

JMB

Actually that formula would return 4.

JMB said:
Your details are a little vague, but something like this would count the
number of "j"'s and "f"'s that occur in C5:C6

=SUMPRODUCT(LEN(C5:C6)-LEN(SUBSTITUTE(C5:C6,{"j","f"},"")))

so if you had
jeff
joe

you would get 3. If you don't get a solution that works for you, perhaps an
example of your data and expected results may help.
Click to expand...
 
Top