Sum = value

[Ken]

Thank you Frank Kabel for solving my earlier issue. Now
it has created another one.... This is what I have so far

Formula in cell B4 =IF('Data Input'!B4<>0,'Data Input'!
B4,"")
Formula in cell B5 =IF(B4="","",IF(B4>=0,Goals_Budget!
$B$5,"not defined"))
Formula in Cell B16 =IF('Data Input'!B16<>0,Data Input'!
B16,"")
Formula in cell B17 =IF(B16="","",IF(B16>=0,Goals_Budget!
$B$5,"not defined"))

Formula in cell B28 =IF('Data Input'!B4+'Data Input'!
B16<>0,'Data Input'!B4+'Data Input'!B16," ")
Formula in cell B29 This is where I'm having a problem,
I keep gettin #value if B4 and B16 are blank. I have
tried a number of different formulas and can't get it to
work. I am aging rapidly over this. Thanks anyone who
can help.

 

[Frank Kabel]

Hi
try
=IF(SUM('Data Input'!B4,'Data Input'!B16)<>0,SUM('Data Input'!B4,'Data
Input'!B16),"")