Your sumproduct formula works. I don't have to open the data file to update the links and the #Value! error is not there anymore.

Thanks for your help!