View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ari Ari is offline
external usenet poster
 
Posts: 12
Default How to lookup multiple values and summing them up in one cell

What was the exact formular you used to figure this out? That is combining
sumif with a vlookup formular?

Thanks.

"Amr Abul Laban" wrote:

I'd like to combine a sumif and vlookup function. Basically I want to lookup
a "Name" in a table and sum up the corresponding grades (multiple cells) in
another table. Can anyone help. Thanks