View Single Post
  #11   Report Post  
Ron de Bruin
 
Posts: n/a
Default counting 0 in a row

Hi Raf

in Dutch you must use

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


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

hallo

dutch language and contineltal separations

ik kee having the same fold message


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


excel keeps having te same problem with te red colord part in the
string
has someone trying the sheet on the website with the string on the
right place K5

http://users.pandora.be/mycl/excel/
it's down loadeble and without a virus i ame using antivir guard xp

if the problem is non existing with an other execl prog then the
problem is here with this version of excel

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