Forum Discussion
Excel indirect reference to intersection of named ranges on different sheet
I have a workbook with a number (expandable) of different data sheets. I have a standard format for each, and each has local named ranges of "data" and "status". On a front Summary sheet I make a (...
This is not specific to INDIRECT. For worksheet-scope names, you have to specify the sheet explicitly for each name.
The formula
=COUNTIF(MySheet!Data Status,"=Flag")
will return #NAME!, while
=COUNTIF(MySheet!Data MySheet!Status,"=Flag")
will work.