Forum Discussion
Bahram2200
Apr 24, 2022Copper Contributor
Countifs
Please help me find out, what is the problem with this formula? I do not have a problem when I write the name of the reference file in the formula, but when the file name is placed in a cell and I g...
HansVogelaar
Apr 25, 2022MVP
You need to use the INDIRECT function for that. It only works if the other workbook is open in Excel.
=COUNTIFS(INDIRECT("'["&F50&"]B '!$Q$2:$Q$2000"),">1400/09/30",INDIRECT"'["&F50&"]B '!$Q$2:$Q$2000"),"<1400/12/30")