Hello all,

Have an issue with graphing while there is an error in the field.

To avoid the "tale" down to zero when using a line graph with some cells
containing zeros I've used the formula {=NA()} which stops the graph
perfectly, however now the very last cell which sums the rest has an error in
it which cannot be graphed.

Would anyone be able to help me with a formula which will allow me to graph
the sum of the cells B2:M2 while ignoring those cells with the #NA error.

Thanks in advance for your help! You all are truly genious!
JR

=SUM(IF(ISNA(B2:M2),0,B2:M2)) as an array formula (Control Shift Enter).
--
David Biddulph

"JR-BHS" wrote in message
...
Hello all,

Have an issue with graphing while there is an error in the field.

To avoid the "tale" down to zero when using a line graph with some cells
containing zeros I've used the formula {=NA()} which stops the graph
perfectly, however now the very last cell which sums the rest has an error
in
it which cannot be graphed.

Would anyone be able to help me with a formula which will allow me to
graph
the sum of the cells B2:M2 while ignoring those cells with the #NA error.

Thanks in advance for your help! You all are truly genious!
JR