One more that uses wildcards:

=if(countif(a3,"*total*")0,b3,"")



gcukarski wrote:

I have a list of names in Column A with values in Column B

A B

George 2
George 3
George Total 5
Adam 5
Adam 6
Adam 7
Adam Total 18

I need an IF formula in Column C that will look for cells in Column A that
have the word "total" in them. This is what I've tried and it doesnt work:

=IF(A3="*total*", B3, "")

Please help.

--

Dave Peterson