Forum Discussion
SUM
Hii, I have attached the file , kindly suggest function
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
- If I type Burmese characters, the preceding letters disappear.
