Getting rid of #value

C

Craig

How am I able to add a column of numbers when one of the numbers in the
formula is itself a formula that results in #VALUE (because that number the
product of zero times another number)?

Thanks
 
J

JE McGimpsey

First, the product of zero and another number shouldn't be giving you
#VALUE!.

Your best bet is to fix or bypass whatever is causing the #VALUE! error.

If you can't do that for some reason, array-enter (CTRL-SHIFT-ENTER or
CMD-RETURN):

=SUM(IF(ISERROR(A1:A20),"",A1:A20))
 
Top