Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,412
    Thanks
    1
    Thanked 0 Times in 0 Posts

    #VALUE when referencing an unopen link

    I have a file that contains "Sumif" formulas that link to an unopened file. Whenever I open the file that contains the "Sumif" formulas first, without having opened the "source" file (i.e., the file that contains the data in the Sumif formula), I get a #VALUE. Any ideas how to fix?

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,412
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Solved-use Sumproduct

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •