Formula to find 2 lowest values across a row and then to combine them

[Yannou]

Hi there,

I was wondering if anyone can help me. What i am trying to do is create a formula to help save me a load of time. I work in sport and the formula that i am hoping to get help with is one that will look across a series of results (times) and pick the the two quickest times and combine them. So, lets say, each row is dedicated to one athlete, in columns ABCD are the results of an athletes 4 attempts in the downhill skiing, so the results are a time. i would like the formula to look at the 4 results and choose the 2 quickest and combine them with the result being in column E. So, for example the results of an athletes attempts are 1 min, 2 min, 3min, 4 min. the formula should then select 1min and 2min as the quickest and combine them so that the result in column E is 3 min. Is this possible? Any help would be greatly appreciated. Thanks

[Andy Pope]

=sum(small(a1:d1,1),small(a1:d2,2))

[Yannou]

Thanks a lot Andy! This is perfect!