Forum Discussion

ITuoh's avatar
ITuoh
Copper Contributor
Aug 11, 2022

#VALUE error after linking 2 documents

Hi all, I would be very appreciative of all responses to help,   I have linked one file to another with the help of a formula. I have been using both files simultaneously for the past weeks without...
excel
office 365
Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 11, 2022
What's your formula?
  • ITuoh's avatar
    ITuoh
    Copper Contributor
    Aug 11, 2022
    My formula was a combination of sum and countifs.
    So basically, wanted to count the number of cell contents which matched a compound criteria.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Aug 11, 2022

      ITuoh 

      COUNTIFS() cannot access closed workbooks.