How to calculate total return for top 10 items

[sachi1982]

Hi All,
I wanted to find out total earnings from top 5 spent items using a formula. I only want to show the total number. I got about 200 items in my list. For each item i got a cost and profit or loss that item make.
From "{=SUM(LARGE(C:C,{1,2,3,4,5}))}" i get sum of top 5 costs. How can i get the profit/Loss for those top 5 cost items.

Below is an example. pleas assist.

Item Name	Cost	Profit/Loss
A	1000	100
B	2000	50
C	3000	250
D	2500	400
E	1400	300
F	5000	150
G	3500	50
H	4000	100
I	1700	200

 

[jasonb75]

What would you expect if there is a tie for 5th place in the top 5 costs?

In this slightly edited version of your example, the green cells represent the top 4, the 2 yellow cells represent a tie for 5th. Should the formulas include 1 or both of them? If only 1 how would you decide which?

Item Name		Cost	Profit/Loss
A		1000	100
B		2500	50
C		3000	250
D		2500	400
E		1400	300
F		5000	150
G		3500	50
H		4000	100
I		1700	200