Duke

Many thanks for your prompt response. I tried your suggestion but,
unfortunately, without success. I still ended up with #N/A if any
cells in those to be added contained a #N/A. I tried to simplify the
prob into a small test as follows:

B6 6
B11 6
B16 6
B21 6
B22 Your suggested array formula

This worked OK and the result in B22 was 24 as expected . However If I
changed cell B21 such that it contained #N/A the test failed and the
result was #N/A in B22.

Woudl still appreciate any other ideas or things to try. Again many
thanks for your suggegstion.

with regards


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