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