=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