How to make a function recognize a text in the function?

Originally Posted by Ericng

Hi there, thanks for the reply.

I understand what you are trying to show. But I want to key in "TotalExposure" into a cell(A1). Then in A2 I will type in =sum(A1). With this way I can change my target range easily without have to type the formula again.

You need to use the INDIRECT function in this case

=SUM(indirect(a1))

ALso avoid using volatile functions like OFFSET to define ranges, especially if you also use the INDIRECT function which is also volatile. You can name ranges using the INDEX function