I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula I have written, but which returns "0" (linking cells
on a single sheet for ease of an example) is as follows:
=IF(SUM(C4)="","",SUM(C4))
Please help!!
Many thanks
--
andyp161
------------------------------------------------------------------------
andyp161's Profile:
http://www.excelforum.com/member.php...o&userid=11654
View this thread:
http://www.excelforum.com/showthread...hreadid=374001