Is it also possible to link the names from the box in row J to M to formula? I have already locked some of them with 4F.

=SUMMERPRODUKT(SUMMERHVIS($C$5:$C$15;$J$20:$J$27;D 5:D15))

Please see attached file

Dilemma 2.xlsx