How can I get the sum of data in a column if there are non number
elements too?

FOr example,

I have got a column with numbers and #NA. When I take the sum or
average, #NA is diplayed. Instead I want to get the actual average of
numbers alone.