Have a EXCEL list, as shown in the figure below:



Now to each category of group 1 ~ 10 score list and weight list multiplied, and the product of the sum, the results on the classification of the "total" column,
Namely, the V3=B3 * * C3 + D3 E3 +... U3 + T3 *

Doing this calculation formula for master how to use? Thank you very much!