Sum Columns with #N/A

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
 
T

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.
 
J

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
 
Top