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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum or Average with #N/A cells 5
Sum and "N/A" 3
How to set a formula if the value is with #N/A 4
Summing all numeric values only in cells in a column 4
Sum Function When Formula Produces #N/A 2
SUM, AVERAGE and PRINT with #N/A cells 11
Sum Column above current cell dynamically using function call 7
#N/A In Cells 7

Back
Top