sumproduct with multi lookup value

Excel.png

Can i use sumproduct to get the total mark? how?

If Total Mark should be the sum of all of the marks, try this in G2:

=SUMPRODUCT((B2:F2=A$11:A$17)*B$11:B$17)

Thanks a lot. It works

You're welcome. Glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.