Formula displays error when text inputed rather than number

B

bshupe12

I am trying to do a summation within an If/Then statement. The problem I am
having is that within that summation there could be values that are text
rather than numbers. I want the formula to just skip over the text and
continue adding the remaining cells. Another problem with this is that any
of the summation cells could contain text.
 
Top