replace #N/A value in EXCEL by 0 ????

[DAVID]

I'm using very large EXCEL Sheet for import of external data. After I make
new calculations, which will be shown in the master-TAB.
I receive many "#N/A" values of course, but I don't care about. I just like
to make total calculation of the colums. But result of calculation for
certain range (column) which contains the "#N/A" values, gives me back a
"#N/A" value.
Is there a way to REPLACE the "#N/A" values by a "0" ????
Just like "REPLACE" ....

Thanks for your help, which would be appreciated

 

[Jerry W. Lewis]

=IF(ISNA(x),0,x)

As long as you are only totalling results, this should work fine. If you
want averages, etc, then you should probably use "" instead of 0.

Jerry