Another way:

=SUM((A1:AD1),-(SMALL(A1:AD1,{1,2,3,4,5,6,7,8})))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Christian Borchgrevink-Vigeland" wrote in message
...
Have Excel 2003. I have a row of about 30 columns width.

See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet.

The numbesr represent points scored in a league. I want the total-column to
just add up all the points, and then deduct automatically the eight lowest
figures.

Possible?

Thanks