Using SumIF to add chosen text from a specific cell

Hi! Ive been on the forums for hours looking for a solution. I am trying to use a SUMIF formula to add choosen text from a specific field on a particular sheet.

Column A contains the text needed to lookup from another sheet, but it is not EXACT.

=SUMIF(Sheet2!A:A,"*BEEF*",Sheet2!D:D)
This is the formula I would normally use, but I don't want to have to type in each of the names for all the rows. I have thousands.

I would like to use =SUMIF(Sheet2!A:A,A3,Sheet2!D:D), but the text is only chosen, so it must have a *. This doesn't seem to work.

Any suggestions? Thanks.

Perfect.
THanks!