SELECT (NULL + 1+345) [Sum of NULL and value.]
NULL
As per the given scenario, the output should be NULL but in case you want to ignore NULL and retrieve overall SUM of the other values, you can use IsNull() check and replace NULL with the 0 (zero) value.