Sumif Keyword

Hello, Im trying to do a sumif function. I have a bank statement loaded in excel and im trying to sumif keywords like walmart, target, subway, but it wont work since the bank statement has more than just the store name in the row it will say for example walmart sotre#xxxx transaction#xxxxx. So how do I add up transactions that are at a certain store or with a certain keyword if the row has multiple words within it other than whats being put into the sumif command? I hope this question is clear I know its probably a little confusion thanks!

ok here is an example I removed dollar amounts in the bank statement but you'll get the idea how can i add up the $ in
column B with the keywords like subway Kroger etc in column E?

lets say i want to know how much i spent at Kroger total on the statement thats what I want a formula for Thanks

ok here use this one instead, its column B im trying to add up

Awesome Thanks so much to both of you thats exactly what i needed! I wish I understood these functions better. One more question sometimes walmart appears as "WM-supercenter" and sometimes it appears at "WAL-MART" on my statement, is there anyway to make it add those up all together since it is two different keywords, im thinking maybe and "or" function i dunno just guessing

Thank You