Hi all,
I have a function (custom for a separate tool) that has many arguments. Since there are many cells referencing all these (18) arguments the file size grows. So i want to combine the arguments in one cell.
Simplified, usually you have SUM(A1, B1) where A1 contains a value and B1 contains a value.
But i want to say SUM(C1) where C1 contains a value like "A1, B1" and then return the sum of cell A1 + B1. I've tried all kind of options (and searched many forums) but cannot find a working solution.
It must be something like Indirect but then for function arguments.
Any help would be highly appreciated.
Many thanks up front!
I have a function (custom for a separate tool) that has many arguments. Since there are many cells referencing all these (18) arguments the file size grows. So i want to combine the arguments in one cell.
Simplified, usually you have SUM(A1, B1) where A1 contains a value and B1 contains a value.
But i want to say SUM(C1) where C1 contains a value like "A1, B1" and then return the sum of cell A1 + B1. I've tried all kind of options (and searched many forums) but cannot find a working solution.
It must be something like Indirect but then for function arguments.
Any help would be highly appreciated.
Many thanks up front!