Calculating from matrix cells

[mantiscore]

Hello,
I would like to ask for your help here because I am kind of strangled myself in my way of thinking up a matrix calculator.
So I have a matrix with 6 columns and 4 rows.
-Each row has a weight of 1, 2, 3 and 4.
At the end of the rows, there is a number (score) that needs to be met. First row has to be 80 (low risk), second 240 (medium risk), third 400 (high risk) and the fourth is 800 (critical risk). These numbers represent the ranges where the score will fall and determine the overall risk.
I need an equation, with which i can properly calculate the score, so if i click on all of the cells from the second row, the number i will get is 240, similarly, if i click on mixed cells, i will get the proper number.
Hope i described it relatively clearly, if i need to elaborate something more, I can do it quickly.
Thanks for the help in advance.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculating from matrix cells
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.