Hi
try the following formula:
=SUM(A1:X1)-SUMPRODUCT(SMALL(A1:X1,ROW(INDIRECT("1:8"))))
--
Regards
Frank Kabel
Frankfurt, Germany
Christian Borchgrevink-Vigeland wrote:
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