Adding Sum of Specific Data In Excel

we can group the data on the name and suming up the resulting group individually.

For implementation options have a look here: