Add and count
Add up the top few numbers
=SUM(TAKE(SORT(B2:B5,,-1),3))How it works in Excel
- SORT puts the numbers highest first.
- TAKE keeps the first 3.
- SUM adds them.
- It needs Microsoft 365.
The idea in general
Line the numbers up from the top, keep the first few, and add them.
What I assumed
- Your numbers are in B2:B5.
Check the result on your own data before relying on it.