SUM when NA errors

[scotball]

OK so I am trying to sum a row but there are NA() errors.

How do I get around this error so that I can sum my row please?

 

[Special-K99]

=IF(NOT(ISERROR(formula)),formula,"")

where formula is your SUM formula

though you should really fix the original calculations/data that are causing the #N/A

 

[VoG]

Try like this

=SUM(IF(ISERROR(A1:D1),0,A1:D1))

Confirmed with CTRL + Shift + Enter.

 

[pgc01]

Hi

Are the numbers non-negative?

 

[scotball]

I am referencing numbers on another tab (all non-negative) where the NA has been added to allow trend graphs to look correct ie dont jump to 0 at the next blank month (more for line charts)...

 

[pgc01]

Hi

Try:

=SUMIF(A1:D1,">0")

 

[scotball]

perfect!!! thank you!!!

 

[pgc01]

You're welcome. Thanks for the feedback.