| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering function results into another function
Sheeloo,
OP is trying to sum across multiple sheets, not just the one value. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sheeloo" wrote: Try =SUM(INDIRECT("'" & N20 & "'!L20")) basically construct a string which gives you the address and pass that to INDIRECT... Since you have only one cell L20 then why are you using SUM? If you just need the value in L20 then use INDIRECT("'" & N20 & "'!L20") Also if worksheet name does not have spaces then you can use =INDIRECT(N20 & "!L20") "excelhurtsme" wrote: Is this possible? =sum(worksheet1:(RESULT OF N20)!L20) with N20 having the formula to display the worksheet name in it? not sure how to put in the (RESULT OF N20) into the formula if it is even possible. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering values without changing the function in the cell | Excel Worksheet Functions | |||
| how do you write format results of a function within a function? | Excel Worksheet Functions | |||
| after entering insert function my cells run down and off page | Excel Discussion (Misc queries) | |||
| Sometimes entering simple function causes it to occupy two cells, why? | Excel Worksheet Functions | |||
| Using function results as parameters in another function | Excel Worksheet Functions | |||
Hybrid Mode
