Need to use if nested function or choose

I have two columns with values. One has values and many Na! And the other has some Na! And I have another column where I am using the aggregate function to calculate using the column with less Na! Values. However my problem is that I want to write a formula where if there is an Na! in one column then it chooses the value from the other column. And then I can use that value for the aggregate function.