Adding to an Empty String

[pibb55]

I have a column, lets call it Column A, that has a formula that returns an empty string ("") if a condition is not met. Column B contains numbers varying from 0 to 50. I want to add Column A to Column B but it is returning #VALUE when I try to add any "" cells.

I want these blank cells to be treated as zeros. I have some other Excel Files that treat them like zeros but I cant figure out why my current sheet won't do the same.


Is it something to do with the Formatting? Problem adding to Formulas? I cant figure it out. Help would be much appreciated.

 

[barry houdini]

Instead of adding A2 and B2 with

=A2+B2

try using SUM like

=SUM(A2,B2)

 

[pibb55]

The Sum(A2,b2) also doesnt work. Any other ideas?

 

[T. Valko]

The Sum(A2,b2) also doesnt work. Any other ideas?

What result do you get using the SUM function?

Are the values in column B the results of formulas? If so, what does that formula look like?

 

[pibb55]

I realized I had a statement before the SUM() that would not let it fire. After removing that, the SUM() works perfect. Thanks!