Pls help Need to sum some "characters"

[testy]

Sorry, may be it's written somewhere but I didn't find...
I need to sum some letter but on each letter corresponds number. I can make it with vloookup, but there will be many vlookups, can you help me to make it better...
this sample table:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]d[/TD]
[TD="align: center"]d[/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]h[/TD]
[TD="align: center"]p[/TD]
[TD="align: center"]p[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]d[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]n[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]h[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]p[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

so i wrote: =VLOOKUP(A1;C4:D7;2;0)+VLOOKUP(B1;C4:D7;2;0)+VLOOKUP(C1;C4:D7;2;0)+VLOOKUP(D1;C4:D7;2;0)+VLOOKUP(E1;C4:D7;2;0)+VLOOKUP(F1;C4:D7;2;0)+VLOOKUP(G1;C4:D7;2;0)
result is 8+8+12+12+14+0+0=54.
I hope it's clear what is the idea.
Thank you!

 

[Asala42]

Since your lookup table is small, you could use:

=COUNTIF(A1:G1,$d$4)*8+COUNTIF(A1:G1,$d$5)*12+COUNTIF(A1:G1,$d$6)*14

 

[RonB1111]

This is a CSE formula that you must confirm with Ctrl+Shift+Enter, do not just hit the Enter key):

=SUM(COUNTIF(A1:G1,C4:C7)*(D4:D7))

 

[testy]

Super. I didn't expect such a short and clear solution. Thank you very match! It's working great, only we have to be careful not to have duplication in decoding (i.e. in c4:c7 not to have twice d), otherwise the result will be incorrect.

 

[RonB1111]

Please clarify "not to have duplication in decoding (i.e. in c4:c7 not to have twice d), otherwise the result will be incorrect". Using my formula, if C7 is changed to d and D7 is changed to 2, the result becomes 58 - why isn't that correct?