Maybe

=SUMIF(A1:A5,"*word*",B1:B5)
sums column B if col A contains a string with Word in

Mike

"LAN186" wrote:

I have two columns A) product description & B) number sold. I want to search
column A (product description) for a specific word or number and where
successful I want to count column B.