as =0+(IF(C3="",0,C3))+(IF(E3="",0,E3))+(IF(G3="",0,G 3))

where the 0+ is probably superfluous


Paul Sheppard Wrote:
Hi Bryan

Thanks, I'd thought of that and that will be my last resort, I'd prefer
to sort the formula though

Paul


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=475314