Forum Discussion
Formula to sumproduct exactly top 12 scores in a range or 20
hi experts I am using the following formula to Sumproduct 12 scores from a range of 20 because I want the top 12 scores to be totalled. =SUMPRODUCT(LARGE(A1:S1,ROW(INDIRECT("1:"&MIN(12,COUNT...
You simply have to modify your formula in T1, to this:
=SUMPRODUCT(LARGE(A1:S1,
ROW($1:$12)))