How to display a 0 value rather than #N/A
 

Hi,

I have many linked sheets with multiple formulas. When I have yet to
populate a field, how can I get the formula to return a zero rather than an
#N/A when I sum my columns?

I'm currently using a combination of =if, lookup and vlookups across
multiple worksheets.

Thanks in advance...

How to display a 0 value rather than #N/A
 

Remove ISNA errors:

=IF(ISNA(your_formula),0,your_formula)

HTH

"sam" wrote:

Hi,

I have many linked sheets with multiple formulas. When I have yet to
populate a field, how can I get the formula to return a zero rather than an
#N/A when I sum my columns?

I'm currently using a combination of =if, lookup and vlookups across
multiple worksheets.

Thanks in advance...

How to display a 0 value rather than #N/A
 

=SUMIF(A1:A6,"<#N/A")

Vaya con Dios,
Chuck, CABGx3



"sam" wrote:

Hi,

I have many linked sheets with multiple formulas. When I have yet to
populate a field, how can I get the formula to return a zero rather than an
#N/A when I sum my columns?

I'm currently using a combination of =if, lookup and vlookups across
multiple worksheets.

Thanks in advance...