Thread: Sum equal cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaimi Blazek Jaimi Blazek is offline
external usenet poster
 
Posts: 1
Default Sum equal cells

Hello.

I currently have this:

Column A Column B Column C

James 5
Kyle 6
Mark 2
Mark 1
James 1
Kyle 4
Adam 5
Adam 1

How do I have Column C be a sum of the numbers in Column B if the "names" in
Column A match, without having the sum of each matching "name" duplicate ( I
only want ONE subtotal for each set of a matching "name" from column A
reflecting the related number from column B)

Thanks.