Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
removed tag from title; edited tags; improved formatting
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

Google Sheets - How to sum 5 largest numbers of 6 numbers across multiple sheets

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 iI use the formula "=SUM(LARGE(C5:L5,{1,2,3,4,5}))"=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)

#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?

Google Sheets - How to sum 5 largest numbers of 6 numbers across multiple sheets

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?

How to sum 5 largest numbers of 6 numbers across multiple sheets

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?

Source Link
Jacob
Jacob
  • 1

Google Sheets - How to sum 5 largest numbers of 6 numbers across multiple sheets

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?