View Single Post
  #7   Report Post  
Bob Phillips
 
Posts: n/a
Default counting 0 in a row

You probably 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.1y51hm_1131386103.6551@excelforu m-nospam.com...

gallo

the three "***" are normalie zero's but this wil do
exept that i keep having aan failur message from excel if i past the
line into the colum K


traing to put everithing in dutch
hoping that it wil work then

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