Forum Discussion
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...
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")