Ian's formula seems to do it

=IF(COUNTIF(F5:J5,"***")2,"NC",SUM(F5:J5)-MAX(F5:J5))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RAF JANSSENS"
wrote in message
news:RAF.JANSSENS.1y4y0n_1131381618.4508@excelforu m-nospam.com...

hallo


the proposed help isnt working

i put the tabel online in thiS directory

http://users.pandora.be/mycl/excel/


THE RESULT OF THE CALCULATION IS DUE IN THE COLLUM K


sorry that the sheet is in dutch but thats the language i ame speaking

hope somone find a sollution for this problem
the version of excel i ame using is 2000

regards raf


--
RAF JANSSENS
------------------------------------------------------------------------
RAF JANSSENS's Profile:
http://www.excelforum.com/member.php...o&userid=28598
View this thread: http://www.excelforum.com/showthread...hreadid=482646