Posted to microsoft.public.excel.worksheet.functions
|
|
how to count if cell "contains" a word
Thank you! This will do it for me, especially since the values can be in any
part of the sequence!
"Rick Rothstein (MVP - VB)" wrote:
Why not this...
=SUM(COUNTIF(A1:A5,{"*abcd*abcf*","*abcf*abcd*"}))
and then it won't matter if "abcd, abcg, abcf" is in there?
Rick
"RagDyer" wrote in message
...
Does this work for you:
=SUM(COUNTIF(A1:A5,{"*abcd, abcf*","*abcf,abcd*"}))
Assuming there is *no* possibility of there being:
"abcd, abcg, abcf"
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cjlatta" wrote in message
...
(Using Excel2003/WinXP) I am trying to count the number of times 2
values
are in a cell. The string may contain the values ",abcd, abcf," or
",abcf,
abcd," The other part that's stumping me is the string could be ",abcd,
abcf, abcg," (or longer). I am wanting to know the number of times the
cell
contains "abcd" and "abcf" no matter what order it's in. I will try to
show
an example below:
Values
1,abcd,
2 ,abcd, abcf,
3 ,abcd, abcf, abcg,
4 ,abcd, abcg,
5 ,abcf, abcd,
I would want to include cell 2, cell 3, and cell 5 in my count, but not 1
or
4. Can I do this?
Any help greatly appreciated.
|