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.

--
Regards,
Tom Ogilvy



"Mark Ruiz" wrote in message
...
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

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/