Hi Bob

Sorry for the delay, I finally try the formula and it works like a treat.
If there is an easy way can you explain the way formula is written I'm quite
curious.

Thanks
AussieBec

"Bob Phillips" wrote:

=SUM(SMALL(B1:G1,{1,2,3}))

and copy down.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"AussieBec" wrote in message
...
John 77 69 73 78 62 69
George 68 73 81 87 89 73
Len 84 77 75 65 87 77

Hi All

With figures above how do I calculate the lowest 3 scores without having
to
sort each row? Your assistance is greatly appreciated, i can't wait to
try a
suggestion tomorrow at work!!

AussieBec