I have a workbook that I keep monthly and it has a new work sheet for every day in the month. I need to create a formula that searches the entire workbook for instances that meet 2 specific criteria. The formula will be in a separate workbook so I need to find out how to reference the source workbook and sheets correctly.
Basically I need something like this, I just need it to search all of the sheets in the source workbook.
=SUMPRODUCT(COUNTIFS(INDIRECT("'"&sheets&"'!"&rng),criteria,INDIRECT("'"&sheets&"'!"&rng),criteria))
Basically I need something like this, I just need it to search all of the sheets in the source workbook.
=SUMPRODUCT(COUNTIFS(INDIRECT("'"&sheets&"'!"&rng),criteria,INDIRECT("'"&sheets&"'!"&rng),criteria))
