Calculating R-squared while ignoring zeros and #N/A

[L.LEE]

Hi

I have a range of data from which I want to calculate r-squared and slope. However, some of the data are zeros or #N/A. How do I calculate r-squared and slope of the non-zero numbers only?

thanks.