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!