Sum Text Values As Numbers and multiply each Number by a value in range of row

I know the subject is very confusing. Let me try and explain
Clipboard Picture (2022.11.02 16.17.11).png

So essentially I am filling row 3 with text values which has a associated numerical value. For e.g. B3 = Low = 10. What I want to do is at the end is to have a formula for H3, where H3=(B3*B2)+(C3*C2)+(D3*D2)+(E3*E2)+(F3*F2)+(G3*G2)+....

Please note that the number of column can increase so cannot be static. I was able to sum all values using the SUM, INDEX & MATCH function but not able to multiply each value by the Row above.

Any and all help will be appreciated.

I have attached the excel file for ease. This is case 1. In case 2 the B2 value is also text and needs lookup against a table.

Worked like a charm!!!!! Thank you. Can you please explain it as well, if it is not too much trouble?

Originally Posted by UWK-87

Worked like a charm!!!!! Thank you. Can you please explain it as well, if it is not too much trouble?

See if this site explains it:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html