Thread: VLOOKUP and SUM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rebecca Rebecca is offline
external usenet poster
 
Posts: 106
Default VLOOKUP and SUM

I am working with a spreadsheet where I need to lookup a text value in one
column and sum the numbers appearing in another column. Is there a way to
combine these two functions? I've figured out how to do the lookup, but not
how to sum the results. It appears that the lookup stops at the first match.
Any suggestions would be appreciated.

Thanks!
Rebecca