I need to have this done by tomorrow. I have two files, basically each
employee has there own "log", it logs hours spent on a project A, B, C, etc.
Then I have one master file that has all the project codes (ie. A, B,C,etc)
and descriptions. I want the master file to link to each individual file and
do a sumIF formula that will sum if it meets the criteria. My current system
displays an error of #VALUE when the linked document is closed. When its
open it then displays the real values. I don't know what is wrong, please
help?