Calculate top 3 scores with conditions

[Deventus]

hi

trying to come up with a way to calculate the top three scores for a row, but based on a condition of either a long or a short run in row 2,

Tried this as a solution, but this only calculates the top 3 scores, if the first record is "long" rather than looking at the full row of conditions

{=IF(E2:R2="LONG",+(LARGE(E4:R4,1)+LARGE(E4:R4,2)+LARGE(E4:R4,3)))}

any ideas

thanks in advance
Adi

[zbor]

Use this, comfirmed with ctrl+shift+enter

Please Login or Register  to view this content.

[Deventus]

spot on, thanks, i was on the right lines but could get it to do the biz

thanks