| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to pass variables as arguments of a function
How to pass variables as arguments to a function call? For example, I want
to sum(Sheet1!E31:E38) where Sheet1 is a variable while E31:E38 is another string variable to be concatenated with Sheet1. I tried assigning Sheet1 to cell A1, E31 to cell A2, E38 to cell C1 and use the function =sum(concatenate(A1,!,B1,:,C1)) but it did not work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to pass variables as arguments of a function
Try using INDIRECT() function
=SUM(INDIRECT("'" & A1 & "'!" & A2 & ":" & C1)) If this post helps click Yes --------------- Jacob Skaria "Excel-craze" wrote: How to pass variables as arguments to a function call? For example, I want to sum(Sheet1!E31:E38) where Sheet1 is a variable while E31:E38 is another string variable to be concatenated with Sheet1. I tried assigning Sheet1 to cell A1, E31 to cell A2, E38 to cell C1 and use the function =sum(concatenate(A1,!,B1,:,C1)) but it did not work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I pass arguments to my formatted empty spreadsheet file? | Excel Discussion (Misc queries) | |||
| function arguments | Excel Discussion (Misc queries) | |||
| IF function with too many arguments | Excel Worksheet Functions | |||
| Showing Error when going to pass a function like this | Excel Worksheet Functions | |||
| Pass variable to NORMINSV function to get only mean value | Excel Worksheet Functions | |||
Hybrid Mode
