Formulae to sum up values including special symbol?

T

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
 
T

Tom Ogilvy

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