Share via

how to insert a formula for the sum of the best 5 out of 6

Anonymous
2013-06-18T01:20:04+00:00

in every row, i have got 6 numbers (eg. 2, 2, 1, 2, 1, 0). what is the formula i should insert to find the sum of the best 5 numbers out of 6 numbers? I can do it manually but I have got many rows (around 500).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-06-18T02:17:33+00:00

    in every row, i have got 6 numbers (eg. 2, 2, 1, 2, 1, 0). what is the formula i should insert to find the sum of the best 5 numbers out of 6 numbers? I can do it manually but I have got many rows (around 500). 

    If you mean by "best" as the largest values, perhaps on of a few ways...

    Just remove the smallest number...

    =SUM(A1:F1,-MIN(A1:F1))

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2013-06-18T02:09:20+00:00

    Hi,

    Let's say numbers are in range B8:G8.  In cell A8, enter this formula

    =SUM(LARGE(B8:G8,{1,2,3,4,5}))

    Hope this helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments