Show #N/A when the total sum equals $0.00

I am using the following formula:

=SUMIF(B143:I143,"<>#N/A")

Basically that will ignore any #N/A's in my row and give me a sum.

But if the sum is $0.00, how can I show #N/A instead of $0.00 for the sum?

This is so I can chart the grand total without the chart showing $0.00 for these dates.

Thanks for any help.

Nick

Try

=IF(SUMIF(B143:I143,"<>#N/A"),SUMIF(B143:I143,"<>#N/A"),NA())