ExcelBanter - INDIRECT function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INDIRECT function (https://www.excelbanter.com/excel-discussion-misc-queries/246576-indirect-function.html)

SixBowls

INDIRECT function

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.

Luke M

INDIRECT function

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.

SixBowls

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.

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