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.

=SUM(IF(ISERROR(A1:A100),0,A1:A100))

an array formula. Must be entered with CNTRL-SHFT-ENTER rather than just
the ENTER key.
--
Gary''s Student - gsnu200800


"Loren Newton" wrote:

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.

=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.