RAF,

Do you have English or Dutch Excel?
Do you have English/American or Continental separators (, for English, ; for
continental)

If English language, English separators, you need to use

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

If English language, Continental separators, you need to use

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

If you have dutch langauge, you probabloy have continental separators, which
means you need

=IF(AANTAL.ANS(F5:J5,0)2;"NC";SOM(F5:J5)-MAX(F5:J5))

--

HTH

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


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

hallo

if i paste the formula in to the right cell i get an erro from excel

i think the version of excel is missing som things

that you all have and i don't

how kan i get the problem solved???

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