Hi,
I vaguely recall that this is possible. For example I have the following formula:
=SUM(MYRANGE)
where MYRANGE is the name of some named range.
Now, I want to be able to pull this word("MYRANGE") from another cell, say A1. What is the formula that would fit the ??? below:
=SUM(???(A1))
Thank you in advanced.
I vaguely recall that this is possible. For example I have the following formula:
=SUM(MYRANGE)
where MYRANGE is the name of some named range.
Now, I want to be able to pull this word("MYRANGE") from another cell, say A1. What is the formula that would fit the ??? below:
=SUM(???(A1))
Thank you in advanced.