Formula excluding #N/A

[Mark Ruiz]

Does anyone know a formula that will sum a column excluding #N/A error. I
have a column that has numbers and #N/A errors but I want to keep the cloumn
the way it is but add the numbers.

Thnx,

MRuiz

 

[Tom Ogilvy]

=SUM(IF(ISERROR(A1:A10),"",A1:A10))

Entered with Ctrl+Shift+enter rather than just enter since this is an array
formula.

 

[MaxLamer]

Try running this code on the column. This will replace the error
messages with whatever you want, say 0.

I hope this helps, although its not exactly what you asked for.



G.

For Each Cell In Selection
If Cell.Formula <> "" Then Cell.Formula = _
"=if(iserror(" & Mid(Cell.Formula, 2) & _
"),""""," & Mid(Cell.Formula, 2) & ")"
Next Cell