Hi,

You may refer to the following

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ari" wrote in message
...
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