Could you share how you did it?

John K

"Amr Abul Laban" wrote:

Thanks for the quick reply. I just figured it out. Unbelievable how it took
me so long to come up with a simple formula. But thanks again, I didn't
imagine that someone would reply this quickly. I will have to use this
resource more often. Thank you very much and greetings from Frankfurt am
Main. Cheers

"Duke Carey" wrote:

Excel can most probably do what you want, however, to get the best advice
from the people here you probably ought to give us abetter idea of how your
data is structured and just exactly what you are trying/wanting to do



"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