A simple way is like this:

=SUMIF(B$1:B$9,D9,A$1:A$9) + SUMIF(B$1:B$9,E9,A$1:A$9) + SUMIF(B$1:B$9,F9,A$1:A$9)

Hope this helps.

Pete