Exercises / Statistics that matter at work · 3 of 6
Total of the top three
Give LARGE a list of positions in curly braces, {1,2,3}, and it returns the three largest values at once. Wrap that in SUM to total them.
Your taskIn E2, add up the three highest scores in B2:B9 in one formula, finding them with LARGE.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Player | Points | Measure | Value | |
| 2 | Arta | 1840 | Top 3 total | ||
| 3 | Bilal | 2315 | |||
| 4 | Chloe | 1975 | |||
| 5 | Dren | 2640 | |||
| 6 | Esme | 2105 | |||
| 7 | Felix | 1720 | |||
| 8 | Gaia | 2480 | |||
| 9 | Hugo | 2010 |