Sum Columns with #N/A

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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.
 
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
 
Back
Top