I am trying to create a formula for the following:

Have spreadsheet locate all columns matching "name" and total those columns
total and provide grand total, please see example listed below

Column A Column D Column G Column H
Dog 10 35
Cat 15 10
Mouse 19 48
Cat 10 2 7
Cat 15 1 19
(All other colomns have various other information listed)
Grand Totals:
Dog = ? (answer: 45)
Cat = ? (answer: 79)
Mouse = ? (answer: 67)

Thanks!!
MD