View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default compare cells and sum if equal

Hi,
Not sure if I understand your question fully, but the following would give
you the answer you want (15) from the sample data:

=SUMPRODUCT(--(A1:A3=B1:B3)*C1:C3)

Change A1:A3, B1:B3 and C1:C3 to suit your actual data.
Note that SUMPRODUCT requires all columns to be of equal length.
Regards - Dave.