Need Formula to fix error

[Guest]

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.

Example

A B C D F
5 Vac 4 3 Sum of A-D(answer should be 12)

I am getting the error in Column F b/c Column B contains text. Any ideas?

 

[Alan]

=SUM(A11) will return 12, SUM will ignore 'Vac' in B1. There must
something else like leading or trailing spaces there. Are you importing this
data? if so try the TRIM function.