Thread: How can I lookup when match has more than one value?
View Single Post
  #42   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Majal Majal is offline
external usenet poster
  
Posts: 2
Default How can I lookup when match has more than one value?
Hi Ray,

Use the SUMIF function:

=SUMIF(A:A, "a", C:C)

Have a great day!
Reply With QuoteReply With Quote