I am trying to sum the largest n values in a range and I would like to specify the n by using a cell.
What I am trying to achieve is something like this;
but instead of taking the sum of the 20 largest values I would like to sum the number of values given within a cell such as $A$1
I have tried to find solutions but haven't yet been quite successful.
Any help is greatly appreciated,
Thanks in advance,