View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Dyck Aaron Dyck is offline
external usenet poster
 
Posts: 12
Default Looking up multiple values for a single name

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?