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?