Instead of doing something like this:

=A1+A2+A3

Do it like this:

=SUM(A1:A3)

The SUM function ignores text.

--
Biff
Microsoft Excel MVP


"Art" wrote in message
...
I need to sum a range of cells. Some of the cells may contain text. If
so,
the function returns #value!. In Lotus 1-2-3, text is treated as 0 for
function purposes. Is there some way to force Excel to do the same, or
another way to get around this problem?