Looking up multiple values for a single name

A

Aaron Dyck

I am trying to look up a name and return a sum of all values in one column
associated with that name. There are between one and five values for each
name. I am only able to return one value for each name, rather than the sum
of all the values. Is there a way to look up all instances of an item and
return the sum of the corresponding values?
 
B

Bondi

Aaron Dyck skrev:
I am trying to look up a name and return a sum of all values in one column
associated with that name. There are between one and five values for each
name. I am only able to return one value for each name, rather than the sum
of all the values. Is there a way to look up all instances of an item and
return the sum of the corresponding values?
Click to expand...

Hi Aaron,

With the information given maybe you can use the SUMPRODUCT()
Maybe something like:
=SUMPRODUCT(--(A1:A5="Name"),B1:B5)
If your names are in column A and values in column B

Maybe the information on this site will be helpful:
http://www.contextures.com/xlFunctions01.html#SumProduct


Regards,
Bondi
 
A

Aaron Dyck

Sorry, perhaps I should have made myself a little clearer. I am trying to
look up a value in the first column of another sheet, and return the sum of
the values of the 30th cell in each corresponding row.

What I've got right now is a =vlookup(Name,DataRange,30), but this only
gives me the first instance, and I need to sum up all instances.
 
B

bj

Sumif should still work
=SUMIF(Sheet2!A1:A5,"a",Sheet2!AE1:AE5)
will work on sheet 1 if what you were looking for was an "a"
 
Top