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
Related Lists on Diigo
-
CC_spreadsheets
Resources utilized in Compu...
Items: 5 | Visits: 57
Created by: Chris Wherley
-
Excel
Resources for Excel and spr...
Items: 12 | Visits: 243
Created by: drew polly
Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »
Join Diigo