Excel formula question

Peter Trounce 20 Reputation points
2026-09-26T20:23:08.9566667+00:00

How do I return the sum of the three highest numbers in a range?

Microsoft 365 and Office | Excel | For home | Windows
0 comments

3 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-26T20:23:20.01+00:00

    Use:

    =SUM(LARGE(A1:A10,{1,2,3}))

    This returns the 1st, 2nd, and 3rd largest values in the range, then adds them together.

    If the range is different, replace A1:A10 with the actual range.

    Example:

    =SUM(LARGE(Q16:Q157,{1;2;3}))

    LARGE(array, k) returns the k-th largest value in a range, and SUM adds those returned values.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Marcin Policht 110.6K Reputation points MVP Volunteer Moderator
    2026-09-26T21:34:39.7866667+00:00

    Use the LARGE function with SUM to return the sum of the three highest numbers in a range:

    =SUM(LARGE(A1:A20,{1,2,3}))

    Replace A1:A20 with your actual range. This returns the largest, second-largest, and third-largest values and adds them together.

    If you want a formula that is easier to extend to a different number of highest values, you can use:

    =SUM(LARGE(A1:A20,SEQUENCE(3)))

    Here, 3 specifies that you want the top three values.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    Was this answer helpful?

    0 comments
  3. Dana D 100 Reputation points
    2026-09-28T20:41:10.8466667+00:00

    You should probably mention how you want to handle duplicates.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.