SUMIF() did it for me. With "Granny Smith" in Sheet1!A1, a series of
different apple names in Sheet2!A1:A10, and apple prices in
Sheet2!B1:B10 the formula on Sheet1!B1 is
=SUMIF(Sheet2!A1:A10,A1,Sheet2!B1:B10)