Hi there, I'm doing a project to test the 80/20 rule - whether it is true that 80% of revenues come from top 20% (by sale) of the clients each year. I'm using the formula below that I got from an excel help website:

=SUM(LARGE(F$2:F$313,ROW(INDIRECT("1:10"))))

F2:F313 is the array of values I'm picking from. LARGE(xxx1:10) tells excel to sum the largest 10 values in the array. (the number 10 in this case came from taking 20% of a total of 50 clients)

Does anybody know how to manipulate this such that INDIRECT("1:10") becomes INDIRECT("1:n") where n can be referenced to another cell?

Reason I'm doing this is because the top 20% of clients is not necessarily 10. Every year there are different numbers of clients and top 20% varies by year, by region etc. (e.g. in a year with 100 clients, 20% would be 20 clients, not 10)

It would simplify my life greatly if I didn't have to change that value for every year I'm testing.

Thank you!