Puzzler - sum of top 3 results

  • Thread starter Thread starter Stewart Walker
  • Start date Start date
S

Stewart Walker

I've got a table with id and results. How would I find the
sum of the top 3 results for each ID - example table

ID Result
id1 5
id1 8
id1 2
id1 4
id1 1
id2 2
id2 2
id2 3
id2 4

I'd like the sum of id1 one to show 17 and id2 sum to be 9
(so it would discount the other 2 as I only want the top 3
results added together)

I hope this makes sense and that someone can work out how
to do this!!!!

TIA

Stewart
MOS - Excel Expert (maybe I should of learned more about
Access perhaps?!)
 
Check out the LARGE worksheet function.

--
Jim Rech
Excel MVP
| I've got a table with id and results. How would I find the
| sum of the top 3 results for each ID - example table
|
| ID Result
| id1 5
| id1 8
| id1 2
| id1 4
| id1 1
| id2 2
| id2 2
| id2 3
| id2 4
|
| I'd like the sum of id1 one to show 17 and id2 sum to be 9
| (so it would discount the other 2 as I only want the top 3
| results added together)
|
| I hope this makes sense and that someone can work out how
| to do this!!!!
|
| TIA
|
| Stewart
| MOS - Excel Expert (maybe I should of learned more about
| Access perhaps?!)
 
Back
Top