I have a summary sheet in a separate workbook with the following function:
When the workbook specified in the formula is closed, I receive a #VALUE! error.
Is there a way to count the cells in the range and criteria I'm interested in when the workbook is closed?
If so, please provide the syntax.