Forum Discussion

Copper Contributor

Sep 09, 2017

Use data from one Workbook for calculations in another Workbook.

Hello, I created a new Workbook by cutting and copying a worksheet from the main Workbook, so the two workbooks have some cross communications in formulas. I saved the new Workbook on the Desktop hop...

Formulas & Functions

Need Help

Detlef_Lewin

Silver Contributor

Sep 09, 2017

Frank,

some functions - like INDIRECT() or COUNTIF() - only work when the source workbook is open.

Frank Natalia
Copper Contributor
Sep 09, 2017
Detlef_Lewin wrote:
Frank,

some functions - like INDIRECT() or COUNTIF() - only work when the source workbook is open.

Thank you, infortunately I used both :-)
I shall fix the problem from anothe side.
- SergeiBaklan
  Diamond Contributor
  Sep 09, 2017
  As a comment. In general INDIRECT works with absolute path, COUNTIF could be changed on SUMPRODUCT which also works with absolute path (COUNTIF not), etc.
  
  Another story is what in real life you have to use this absolute path as parameter defining it manually or based on some rules, e.g. parent folder for current subfolder.
  - Frank Natalia
    Copper Contributor
    Sep 12, 2017
    SergeiBaklan wrote:
    COUNTIF could be changed on SUMPRODUCT which also works with absolute path (COUNTIF not), etc.
    
    Thank you. I shall try to replace Countif by Sumproduct.
    Yes, I try to creat a parant folder to work with subfolders.