I am trying to link to another excel file using a sumif formula and get a
#value! if both files are not open. I have tried the Control Shift Enter and
changing the formula but am still not getting it. The formula is
=SUMIF([ACPS.xls]Monthly!$D$1:$R$1000,$D6,[ACPS.xls]Monthly!K:K). Any
suggestions?