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?

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/xlFunctio...tml#SumProduct


Regards,
Bondi