Formulae to sum up values including special symbol?

[tanks1308]

Hello all, I was trying to figure out if there is a way to write
formulae to sum up the values in the whole column. In this column
there are plenty of cells which has variable like #N/A. Appreciate i
you guys can help me with this problem. Thanks

 

[Frank kabel]

Hi
better would be to change the formulas and avoid #N/A
errors. But try

 

[Tom Ogilvy]

=sum(if(iserror(A1:A100),"",A1:A100))
Entered with Ctrl+Shift+Enter rather than just Enter since it is an array
formula.