Hi Duke, MrShorty, Aladin

With your help I managed to fix my problem successfully. I finally
added a
=IF(ISBLANK(B5etc),0,'function) to the front end of my function in B6
(and similar cells) and everything worked. Can now add B6,B11,B16 etc
with straight forward formula. Had a slight addition problem because I
already had seven levels of nesting, but managed to overcome that

Many thanks for your kind input, you all got me thinking around the
prob and into some unfamiliar ways of using some functions.

my best regards


--
Jeeper
------------------------------------------------------------------------
Jeeper's Profile: http://www.excelforum.com/member.php...o&userid=24107
View this thread: http://www.excelforum.com/showthread...hreadid=377157