Need Formula to fix error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=SUM(A1:D1) 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.
 
Back
Top