SUM

[AlexEanbu]

Hii, I have attached the file , kindly suggest function

[#2]

If I type Burmese characters, the preceding letters disappear.

[#3]

@AlexEanbu 

Which version of Excel do you have? In Excel in Microsoft 365 or Office 2021 and later,

=SUMPRODUCT(B2:B30,VLOOKUP(A2:A30,H2:I93,2,FALSE))

should work. In older versions, you should confirm the formula by pressing Ctrl+Shift+Enter