Relative values and NAME

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use relative cell values when using the NAME function? I thought I
had succeeded in doing this but as soon as I sorted the spreadsheet to a
different order, the SUM function I used to pick up the values in the named
cells collected the values from new cells that were in the position of the
old named ones.
 
Hi
sorting does not change the cell references. You always reference a cell and
not it#s contents
 
You must log in or register to reply here.

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

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Indirect function and relative references 4
Naming Cells Using Relative Cell References 1
Update cell value based on name and specific date 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Counting by color 3
How do I have a cell value define a dynamic named range? 15

Back
Top