Can't get sumif to only return true for whole words rather than text matched within words

Hoping for some help, Im sure it's very simple but it's been a long day.

I have a spreadsheet which I use to estimate my required stock. I have my past years sales in one sheet and use a sumif on the next sheet to lookup the values of each of my stock items and return the number sold to a new sheet.

The problem I have is it is returning values which contain the specific text as part of the word and not just as the word on its own. So for instance, I want to look up how many Bride items I have sold, It is also returning mother of the bride, bridesmaid, chief bridesmaid etc. The cell does contain other sales details also. Ie [Message on heart Little Sister,Length 18",Packaging Organza bag] WHere the data I wish to extract would be "little sister"


The code I have is: =SUMIF(Data!AL:AL,"*"&A57&"*",Data!O:O) I know its probably very simple but would really appreciate some help.

Another issue is that I also search for terms such as godmother, where on some occasions it may be god mother and others may be godmother. I am thinking of making 2 separate rows for each and then totalling unless there is a work around.

Thanks x

The '*' act as wildcards. Convert to
=SUMIF(Data!AL:AL,A57,Data!O:O)

For your second question around godmother. Yes, probably easiest to just have both separately and then add together.