Formula excluding #N/A

  • Thread starter Thread starter Mark Ruiz
  • Start date Start date
M

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
 
=SUM(IF(ISERROR(A1:A10),"",A1:A10))

Entered with Ctrl+Shift+enter rather than just enter since this is an array
formula.
 
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
 
Back
Top