I have a spreadsheet where we are keeping scores for golf across 6 weeks but we are only taking the best 5 scores from the 6 weeks. Each week (1-6) has its own sheet (tab)

I need to get the sum of 5 the best 6 scores. Each score is on its own sheet. (Week 1, week 2, etc.)

when I use the formula =SUM(LARGE(C5:L5,{1,2,3,4,5})) the result is:

#N/A Wrong number of arguments to LARGE. expected 2 arguments but got 7 arguments)

Is there a different formula that will allow the "range" to be 6 different cells from 6 different sheets instead of a single range from a single sheet?

1 Answer 1


The formula you've specified doesn't appear prima facie to correspond to the layout of your sheets as-described, but the formula on its own will not work because you are supplying an array to the 2nd argument of LARGE but haven't wrapped it in ARRAYFORMULA. If there are numerical values in C5:L5, then this will work: =arrayformula(sum(large(C5:L5,{1,2,3,4,5})))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.