Has anyone got a solution for calculating capped point score per pupil in Excel? So far I've got

SUM(LARGE(L2:BF2,{1,2,3,4,5,6,7,8}))

but this doesn't take into account the GCSE weighting for equivalencies e.g. if a BTEC subject is in the eighth highest add this twice.

I already have a row with GCSE weighting per subject on it so I almost need to combine the above formula with SUMPRODUCT...somehow?