Thread: Look UP Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Look UP Formula
Hi,

Try using SUMIF() in cell C2

=SUMIF(B5:B250,B2,E5:E250)

Regards,
Bondi

Reply With QuoteReply With Quote