Thanks, I did not realize that =sum(a1,b1) when a1 = "" would not return
#VALUE.


Peo Sjoblom wrote:
Post the formula that returns the value error, a value error occurs when
you calculate with text like "" so you can replace it with 0 instead if
you add it or you can use functions that ignores text like SUM or SUMIF