Hi!

Instead of this: = A1+A2

Use this: =SUM(A1,A2)

The SUM() function will ignore TEXT entries.

Biff

"Joe Miller" wrote
in message ...

I wish to refer to a column of numbers in a formula where a zero is
represented by a blank rather than the number zero in the reference
column. Is there a function which will convert the blank to a zero to
avoid an error?
(e.g.)
the following results in an error in cell B1 so I guess I need a
function which I can use in the formula in B1 which will convert the
blank in A1 to a numeric zero?
CELL A1 CONTAINS blank
CELL A2 CONTAINS 2
CELL B1 CONTAINS =A1+A2


--
Joe Miller
------------------------------------------------------------------------
Joe Miller's Profile:
http://www.excelforum.com/member.php...o&userid=29900
View this thread: http://www.excelforum.com/showthread...hreadid=570145