How to combine two columns (with missing data)?

jasongao — Thu, 30 May 2019 04:28:50 GMT

got a table with missing data like this:

Need to combine it it to one column

Column3

I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it?

Thanks!

Re: How to combine two columns (with missing data)?

jasongao — Thu, 30 May 2019 04:53:16 GMT

OK. I figured out. I need to use sum() instead of +.