Thank you very much. I tried to translate it from english to norwegian but I didnt get the right result. Is there something wrong with my formula? I pasted the formula in D19..

=SUMMERPRODUKT(SUMMERHVIS($C$5:$C$15;INDEKS($J$20: $M$27;SAMMENLIGNE($C19;$J$19:$M$19;0));D$5:D$15))

Transelation, from english to norwegian:

Sumproduct = summerprodukt, sumif = summerhvis, index = indeks, match = sammenligne,

We also use ";" instead of ","

Dilemma 3.xlsx