Sum Error While Graphing

[JR-BHS]

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

 

[David Biddulph]

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