Automatically summing together groups of numbers in Excel.

Hello,  I am trying to sum together groups of numbers in Excel based on groupings.    As in the attached example, certain weights are grouped according to the Shop number.    Is there a way to...