Using SUMIF with criteria of cell containing a specific character
 

I am trying to use SUMIF with the criteria of a specific character (%) being
anywhere within the text of the cells in the criteria range. The character is
not always in the same place within the text and never starts with the
character so I was trying to use FIND but I couldn't come up with a way to do
it.
i.e. Summing column B cell values where column A cells have a "%" in it.
A B
1 Carl Smith 10
2 Jim Hill% 15
3 Steve Camp 5
4 Mary% Levy 30

Using SUMIF with criteria of cell containing a specific character
 

=SUMIF(A2:A50,"*%*",B2:B50)

--


Regards,


Peo Sjoblom

"Bob Arnett" wrote in message
...
I am trying to use SUMIF with the criteria of a specific character (%)
being
anywhere within the text of the cells in the criteria range. The character
is
not always in the same place within the text and never starts with the
character so I was trying to use FIND but I couldn't come up with a way to
do
it.
i.e. Summing column B cell values where column A cells have a "%" in it.
A B
1 Carl Smith 10
2 Jim Hill% 15
3 Steve Camp 5
4 Mary% Levy 30

Using SUMIF with criteria of cell containing a specific character
 

You can use wildcards with SUMIF, so try this:

=SUMIF(A:A,"*%*",B:B)

Hope this helps.

Pete

On Nov 7, 12:13*am, Bob Arnett
wrote:
I am trying to use SUMIF with the criteria of a specific character (%) being
anywhere within the text of the cells in the criteria range. The character is
not always in the same place within the text and never starts with the
character so I was trying to use FIND but I couldn't come up with a way to do
it.
i.e. Summing column B cell values where column A cells have a "%" in it.
* * A * * * * * * * * * * *B
1 *Carl Smith * * * *10
2 *Jim Hill% * * * * *15
3 *Steve Camp * * * 5
4 *Mary% Levy * * 30

Using SUMIF with criteria of cell containing a specific character
 

Well, duh. Of course one would use a wildcard... what's wrong with me.
Thanks to both of you for your responses.


"Bob Arnett" wrote:

I am trying to use SUMIF with the criteria of a specific character (%) being
anywhere within the text of the cells in the criteria range. The character is
not always in the same place within the text and never starts with the
character so I was trying to use FIND but I couldn't come up with a way to do
it.
i.e. Summing column B cell values where column A cells have a "%" in it.
A B
1 Carl Smith 10
2 Jim Hill% 15
3 Steve Camp 5
4 Mary% Levy 30