You are almost close. Try this

=SUMIF(A1:A1000,"*LCI*",B1:B1000)

If this post helps click Yes
---------------
Jacob Skaria


"Jay" wrote:

I have long texts in rows of column A and values in Column B. The
sheet has 1000 rows.
I want to add values in column B if the texts has "LCI" in it. I
tried sumif(A1:A1000,"LCI",B1:B1000), but gives value 0.