When using the following sumif, if the sheet that it is linked to is not open, I get #Value! errors. But when it is open on my desktop, the errors go away, Any ideas?
=SUMIF('\serverfolderMaster Files[Master1-BS12x.xls]SD'!$E$10:$FD$10,D$5,'\serverfolderMaster Files[Master1-BS12x.xls]SD'!$E$138:$FD$138)
=SUMIF('\serverfolderMaster Files[Master1-BS12x.xls]SD'!$E$10:$FD$10,D$5,'\serverfolderMaster Files[Master1-BS12x.xls]SD'!$E$138:$FD$138)