Posted to microsoft.public.excel.worksheet.functions

Gdcprogrc

external usenet poster

Posts: 5

Can you use INDIRECT in 3-D references?

Thanks a lot, Harlan, you were a big help!

"Harlan Grove" wrote:

Gdcprogrc wrote...
For example
=SUM(INDIRECT(C10))
where C10 would contain
="Sheet2:"&"Sheet3!"&"A"&ROW()
always returns #REF!.
....

No. INDIRECT can only return range references. 3D references are never
range references.

You could use a list of worksheet names, e.g., WSLST referring to

={"Sheet2","Sheet3"}

then use the formula

=SUMPRODUCT(N(INDIRECT("'"&WSLST&"'!A"&ROW()))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Indirect cell references ????	Stephen Rainey	Excel Discussion (Misc queries)	9	May 3rd 06 05:22 PM
Changing cell references in formulas to names and back again.	Aaron	Excel Discussion (Misc queries)	4	April 25th 06 11:12 PM
Using Indirect en direct cell references	Bart Schouw	Excel Discussion (Misc queries)	2	January 13th 05 01:05 PM
Indirect references in a linked formula	Markshnier	Excel Worksheet Functions	0	November 15th 04 03:36 AM
Indirect references in a linked formula	Markshnier	Excel Worksheet Functions	1	November 15th 04 02:49 AM

All times are GMT +1. The time now is 07:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us