Suming up a Lookup

B

Byan

I am trying to take a word and sum up from a different spread sheet that has
a list of words and amounts in the cell next to the word. I want a cell that
will find that word in the list and sum up the amounts that are next to that
word every time it comes up. There is examples below. How ever my list is
going to be a lot longer, just need an equation to get started.

For example my list would be:
A B
1 Upgrade 305
2 Saftey 210
3 Upgrade 195
4 Upgrade 150
5 Saftey 100
6 Added Life 200
7 Total 1,160

I am trying to get a Cell on another Page to display the totals of each,
example:
A B
1 Upgrade 650
2 Saftey 310
3 Added Life 200
4 Total 1,160


Thanks anyone that can help
 
D

Duke Carey

=sumproduct(--(Sheet1!A1:A1000="Upgrade"),Sheet1!B1:B1000)

ought to do it for you
 
A

Aladin Akyurek

Let A1:B7 on Sheet1 house data.

In B1 on Sheet2 enter & copy down:

=SUMIF(Sheet1!$A$1:$A$7,A1,Sheet1!$B$1:$B$7)
I am trying to take a word and sum up from a different spread sheet that has
a list of words and amounts in the cell next to the word. I want a cell that
will find that word in the list and sum up the amounts that are next to that
word every time it comes up. There is examples below. How ever my list is
going to be a lot longer, just need an equation to get started.

For example my list would be:
A B
1 Upgrade 305
2 Saftey 210
3 Upgrade 195
4 Upgrade 150
5 Saftey 100
6 Added Life 200
7 Total 1,160

I am trying to get a Cell on another Page to display the totals of each,
example:
A B
1 Upgrade 650
2 Saftey 310
3 Added Life 200
4 Total 1,160


Thanks anyone that can help
Click to expand...

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
 
Top