=SUMIF(A:A,"<"&99^99)

if you want to sum column A, entered normally

--


Regards,


Peo Sjoblom

"Loren Newton" wrote in message
...
I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the
total
of the numbers entered when there are the errors in the sumed cells.
Thanks.