G Guest Oct 4, 2006 #1 I need to be able to count items in a column, but also have it add multiple items with in one cell. Any ideas?
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 Oct 4, 2006 #2 =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
=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
G Guest Oct 5, 2006 #3 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.
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.
G Guest Oct 5, 2006 #4 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...
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...
