Calculating Sum Column and ignoring Na [duplicate]

Question

I am trying to create a Total sum column that adds up the values of the previous columns. However I am having difficulty if there is an NA. If there is an NA in the row, my script will not calculate the sum.

How do I edit the following script to essentially count the NA's as 0, or just ignore them completely but still calculate the sum. I don't want to actually change the NA to 0.

CTDB %>% mutate(SCARED_TOTAL_CHILD = CTDB %>% rowwise() %>% 
SELECT(SCARED_BREATHE_CHILD:SCARED_SHY_CHILD) %>% rowSums()) -> CTDB

Thank you!!

Answer 1

Add in na.rm=TRUE

i.e

rowSums(na.rm=TRUE)

Answer 2

ummm, I think the help for the function outlines how to omit NAs from the calc.... try rowSums(.,na.rm=T)