#N/A error messages

[Loren Newton]

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.

 

[Gary''s Student]

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

an array formula. Must be entered with CNTRL-SHFT-ENTER rather than just
the ENTER key.

 

[Peo Sjoblom]

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

if you want to sum column A, entered normally

--


Regards,


Peo Sjoblom