Home
eelirac 's Library tagged → View Popular
16 Nov 09
Excel Misc Indirect function across sheets
-
With INDIRECT, the cells must then be in quotes, like
=SUM(A1&"!C1:C10") -
You need to remember to put explicit text strings in quote marks, and use
CONCATENATE (or the & operator) to glue the final string together.
If D1 contains -1, then ="'Sheet B'!C"&D1+2&":C10" would return the string
'Sheet B'!C1:C10 which is what you are looking for inside the parentheses of
your SUM() function.
Sponsored Links
Ads by Google
Top Contributors
Groups interested in Excel
Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »
Join Diigo