Use the SMALL() function.
Suppose your data is in A1:A40. In B1:B8, set up a series of number from 1
to 8. In C1 enter the formula

=SMALL($A$1:$A$40,B1)

Fill down to C8.

Your formula:

=SUM(A1:A40)-SUM(C1:C8)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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