Summation top x of y

[BearingGuy]

IF I have a list of values (12) and I only want to auto sum the top 10 of 12 values; is there a formula to do this? There are about 223 lists of 12 valus where I wish to apply this sum logic...

[Phillycheese5]

If your data is in column A, then try this...


=SUM(LARGE(A1:A12,ROW(INDIRECT("1:10"))))

entered as an array... ctrl+shift+enter


Phillycheese5

[BearingGuy]

THANKS Phillycheese5!!
Didn't exactly work but it did provide me a solution that works for my hockey pool!