wow you have Sheetz there? impressive lol

OK try this...
=SUMIF($E$2:$E$23,"*"&"sheetz"&"*",B2:B23)

That will give you the basic concept of what you need to do. You could put all the store names in a table, and reference them if you want to, replave the name in the formula with a cell ref