I am using AverageIf to link to another workbook. I've read that the "if" family do not like source workbooks to be closed, so I was going to modify formulas to somehow use SumProduct, when I noticed that half of the instances of the formula did return results, while others returned #Value...