INDIRECT function

S

SixBowls

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.
 
S

SixBowls

Thanks. I can stop pulling my hair out!

Shawn

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top