Posted to microsoft.public.excel.misc

SixBowls

external usenet poster

Posts: 26

INDIRECT function

Thanks. I can stop pulling my hair out!

Shawn

"Luke M" wrote:

Unfortunately, no. The INDIRECT function does not support 3D references.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"SixBowls" wrote:

Can the INDIRECTfunction be used to create a multiple worksheet sum? The
following formula works:
=SUM(Sep09:Jan09!C9)

I would like to change it to something like this:
=SUM(INDIRECT(B3&":"&B4&"!"&B5))

b3 is Sep09, b4 is Jan09, b5 is C9

The formula returns a #REF! error.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Using INDIRECT Function and INDEX Function	ChristopherG	Excel Discussion (Misc queries)	1	June 10th 09 04:07 PM
Indirect function	Eden397	Excel Discussion (Misc queries)	6	February 21st 08 08:28 PM
How to use indirect function?	Eric	Excel Discussion (Misc queries)	2	January 30th 07 03:57 PM
INDIRECT function inside AND function	Biff	Excel Worksheet Functions	3	September 23rd 06 07:20 PM
INDIRECT function	Paul K.	Excel Worksheet Functions	0	February 10th 05 09:53 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us