Can you use INDIRECT in 3-D references?
What does one do if your worksheets are named, June, July, August etc.?
In that case, use Harlan's suggestion.
Biff
"Gdcprogrc" wrote in message
...
Thanks Biff. That seems to work.
What does one do if your worksheets are named, June, July, August etc.?
"Biff" wrote:
Hi!
Try it like this:
C10 = ="A"&ROW()
=SUMPRODUCT(N(INDIRECT("Sheet"&ROW(INDIRECT("2:3") )&"!"&C10)))
Biff
"Gdcprogrc" wrote in message
...
For example
=SUM(INDIRECT(C10))
where C10 would contain
="Sheet2:"&"Sheet3!"&"A"&ROW()
always returns #REF!.
However, ="Sheet3!"&"A"&ROW() as the Cell C10 entry will work fine.
|