Formula to total items from a drop list with values in several col
 

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

you could sumif each column using a sumif formula and then sum the respective
rows.Or are you wanting a drop down box to select say cat and get the
appropriate sum....sumproduct maybe?(I am not quite up with the play on that
function......:) )
--
paul
remove nospam for email addy!



"Rescues Mittens" wrote:

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