Referring to a named range

D

Darin Kramer

Hi there,

is it possible within a formulae to refer to a named range, not by
stating the named range, but by refering to a cell, where the contents
of a cell is a named range?

For eg, if cells a1 to a5 contain numbers and I name that reference
Col_A, then if I want the total I can just type = sum(Col_A).

Now I want to do exactly the same thing, but instead of the name Col_A
in the formulae, I want to use a reference. Thus in cell B1 I have the
words Col_A. The formulae =sum(b1) obviously doesnt work. Something like
= sum(name(b1)) ?

Regards

Darin




*** Sent via Developersdex http://www.developersdex.com ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top