Named Range and multiple entries in Define Name

  • Thread starter Thread starter Gabor
  • Start date Start date
G

Gabor

Lectori Salutam (greetings to the reader)

The August 17 issue of the PC Magazine p.73 describes a
multiple entry "Define Name" window.
The article says:(Cursor on col.A)
"Select Insert,Name, Define from the menu.In the Edit box
at the top enter A and in the Refers to box at the bottom
enter:
=OFFSET(INDIRECT("R1C",),,,ROW()-1) "
SOFAR I DID THIS ALL.
UNDER NAMES IN THE WORKBOOK I HAVE TWO LINES OF "A".s,
IN THE REFERS TO LINE AT THE BOTTOM I HAVE THE
ABOVE "OFFSET...." FORMULA.
THE REST I DID NOT GET:

"then click on Add,enter S and =SUM(A) in the same
way,click on Add again,and click on Close."

The DEFINE NAME picture of the author's shows two "A".s
and an "S" in three lines in the names in notebook,and the
above formula:"OFFSET..." on the bottom line:REFERS TO.

How does one enter S and +SUM(A) described by the author
that I could not duplicate.


Thanks!
 
I didn't read the article but if you want to define a1:d last row in a, I
would use
=offset($a$1,0,0,counta($a:$a),4)
have a look at HELP index for OFFSET to learn how to use offset.
 
Back
Top