try
=sumif(criteria range,criteria,datarange)

"Aaron Dyck" wrote:

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?