Hi All,
I have a formula that is referrencing a closed workbook and returning #ref! error for all but two of the matches. But, the values appear when the source workbook is open. I have tried updating links etc. but to no avail :(
Following is the formula I have been using to sum a range...