Sum of Lowest Rankings

[Celticshadow]

Hi Forum

I have as attached in the google sheets link

column A is the race id
column B which lists horses names
column C I have the starting price odds of said horses
column D I have the rank of those Starting price odds
column E I have the finishing position of those horses

What I would like if possible is (with a formula) to put in column F the sum of the two smallest ranks from column D that would be taken from the first 3 finishing positions in column E.

Thus

first pos is 1 and its coinciding Price rank is 4
second pos is 2 and its coinciding Price rank is 5
third pos is 3 and its coinciding Price rank is 9

Therefore 4 and 5 need to summed which equals 9 and placed in column D.


Many thanks for looking and I look forward to any help forum may be able to give me.

Sum Lowest Ranks

docs.google.com

Regards

 

[Fluff]

You're welcome & thanks for the feedback.