SUMIF? using contains

L

LAN186

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.
 
M

Mike H

Maybe

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

Mike
 
Top