```
+-----+-----+-----+-----+-----+-----+-----+-----+
| | A | B | C | D | E | F | G |
+-----+-----+-----+-----+-----+-----+-----+-----+
| 1 | 5 | 6 | 5 | 9 | 4 | 8 | 3 |
+-----+-----+-----+-----+-----+-----+-----+-----+
```

Considering the above sheet. I am looking for a way in Excel/Calc to get the top 5 numbers.

The only way I can think to do it so far is to use 5 different LARGE functions

```
=LARGE(A1:G1, 1)
=LARGE(A1:G1, 2)
=LARGE(A1:G1, 3)
=LARGE(A1:G1, 4)
=LARGE(A1:G1, 5)
```

That would give me the five highest numbers. I was wondering if there was a way to do this with a single formula that would return:

```
9, 8, 6, 5, 5
```

into a single cell?

Another question, instead of printing them out, I would also like to SUM the numbers in a different cell.