Can you use CountA to add multiple items within one cell?
Actually that formula would return 4.
"JMB" wrote:
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.
"Teacher in a quandry" wrote:
I need to be able to count items in a column, but also have it add multiple
items with in one cell. Any ideas?
|