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
Bookmarks