Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add and delete items from a list box or drop down box? | Excel Discussion (Misc queries) | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |