Adding up the top 8 values

Morning,

I posted an earlier query asking how to work out the average value from the highest 8 values from a row of 12. The boss has now said we don't need an average just a total

In cell Q2, I would like it to look at all the values in cells in B2 to N2, and then add up the highest 8 scores; if there are less than 8 values, I would like it to add up what there is.

Any help would be appreciated.

Many thanks

Simpy choose any answer You got here
http://www.excelforum.com/excel-new-...-best-8-a.html
and change aver. into sum

Same formula as before.

=SUM(LARGE(B2:N2,{1,2,3,4,5,6,7,8}))

Try this in Q2

Please Login or Register  to view this content.

Drag/Fill Down

Note
Either way, you might have anomalous results if there are multiple duplicate scores in any one row.

[EDIT]
Go with Fotis, that's probably the way to interpretate your question, only counting 8 cells.

...if there are less than 8 values, I would like it to add up what there is.

In this case, modify Zbor's formula from your other THread.,,

=SUM(LARGE($B2:$N2,ROW($A$1:INDEX($A$1:$A$100,MIN(8,COUNT($B2:$N2))))))

Array formula.(C+S+E)

Or your formula Fotis,
pre 2007

Please Login or Register  to view this content.

Later versions

Please Login or Register  to view this content.

Or for all versions

Please Login or Register  to view this content.

I never used this formula in this way Marcol!

Nice work! Simple and nice!