Total of top 5 cells

[bsimardjr]

I hope I can find some help here. I'm trying to add the top five values in a column of about 15 entries. They will not be in any special order and sorting them in order is not an option.

Thanks
Bob
New guy to the forum.

[sglife]

Is this what you want?

=LARGE($A$1:$A$15,1)
=LARGE($A$1:$A$15,2)
=LARGE($A$1:$A$15,3)
=LARGE($A$1:$A$15,4)
=LARGE($A$1:$A$15,5)

[Paul]

If you'd like to SUM the five largest values in a range, try:

=SUM(LARGE(A1:A15,{1,2,3,4,5}))

[bsimardjr]

Thank you, in less than 10 minutes I have my answer. I appreciate the quick help.

Thanks
Bob
Chelmsford, MA

[bsimardjr]

The formula that Paul supplied =SUM(LARGE(A1:A15,{1,2,3,4,5})) works great for me. Now I am wondering if it can be modified to either display zero as a result if there is less than 5 entries in the column or just an empty cell as a result.

Thanks
Bob

[Paul]

Hi Bob,

You can probably adjust the formula to:

=IF(COUNT(A1:A100)<5,0,SUM(LARGE(A1:A100,{1,2,3,4,5})))

[bsimardjr]

Paul
Thanks again for your help, it works great. This is a great forum.

Bob
Chelmsford, MA