If you're using the SUM function it ignores text and this is essentially the
same as evaluating it as 0.

A1 = 10
A2 = XX
A3 = 10
A4 = NA
A5 = 10

=SUM(A1:A5) returns 30

--
Biff
Microsoft Excel MVP


"Jared" wrote in message
...
I am trying to sum a row, but some cells have text that explain why the
data
is missing. I would like any text to be summed as zeros, but I can't seem
to
figure out how to make excel do that. Any information you could give me
would be appreciated.