Ignore text when sum cells

[evoxfan]

I have two columns with numbers, blanks, and text.
I want to sum these two columns (C1=A1+B1) if there is a number in either
column, leave a blank if both columns are blank, and ignore text.
When I have text in these columns, I get: #VALUE!
How can I ignore text and return a blank instead of zero if there are two
blanks?

Example:
IN ABV 204 #VALUE!
IN ABV IN ABV #VALUE!
IN ABV IN ABV #VALUE!
15,327 264 15,591


Thanks in advance.

 

[Richard Schollar]

Hi

Try

=IF(COUNT(A1:B1)>0,SUM(A1:B1),"")

copied down

Richard

 

[T. Valko]

Try this:

=IF(COUNT(A1:B1),SUM(A1:B1),"")