View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mike
 
Posts: n/a
Default look up function and sum values

I have a large spreadsheet that has vendor #s in column A and amounts in
column B. How do i get excel to look at all the matching vendor #s in column
A and add up all the corresponding values in column C and return the vendor #
and totals? There are multiple orders from the same vendors and I just want a
total for each returned along with the vendor #.