Sum Columns with #N/A

[Bob]

I have some formulas in cells in a column that produce
#N/A if there's no entry made in a given row. I don't
want to delete the formula logic. I used conditional
formatting so the #N/A is not printed, but I am unable to
sum the column if it contains either a #N/A or DIV/0.

Is there any way I can retain the logic in the cells, not
show the error messages and still be able to sum the
columns?

Thanks,
Bob

 

[Thomas]

This was just posted a few hours ago
=SUM(IF(ISNUMBER(A1:A5)=TRUE,A1:A5))
This must be array entered Control-shift-enter instead of just enter.

 

[John Wilson]

Bob,

Whilst all the other replies that you rec'd will work, the best
practice would be to change your original formulas to not
get the error in the first place.

Example:
=IF(ISERROR(yourformula),"",yourformula)

John