The question seems easy but I could not find an answer for it. I have the following column in my data frame and I want to take average of the column excluding the number of NAs. $X2016.Q1 : int 47 53 75 97 NA NA 23 NA 43 NA .... Does anyone know how to do that? Thanks for any help Elahe