I am working on a worksheet that will be updated yearly. Consequently, the
number of rows used will change. I have pasted the links down through the
maximum number which could be used. I am now attempting to do a sum of the
cells. Because some of them do not contain data however, it is resulting in
an #N/A. Suggestions?

I posted this a few weeks ago, and there has been no reply. I need help.
Please.

"Catherine" wrote:

I am working on a worksheet that will be updated yearly. Consequently, the
number of rows used will change. I have pasted the links down through the
maximum number which could be used. I am now attempting to do a sum of the
cells. Because some of them do not contain data however, it is resulting in
an #N/A. Suggestions?