Hi,

I couldn't find the right formula for this... I'd like to sum top 10 values from a range of values in cells. Currently only way I can think of is to sort all the values first and then count the top 10 cells. But is there a way to find the top values with a automatic formula, which would fit to one cell?

Example:

A
4
6
8
3
13
4
16
11
9
2
8
8
10
5

Sum from top 10 values would be 96... But how to reach this with a formula?