mariosv wrote > > Introduce: > A2: 1 > A3: 2 > A4: 3 > > Create a label range: > Menu/Insert/Names/Define/Adds: > Name: SumRange > Range: $Sheet1.$A$2:$A2 > $A$2 is an absolute reference. > $A2 is a relative reference. > > Introduce: > B2: =SUM(SumRange) result 1 > Copy B2 to B3: > B3: =SUM(SumRange) result 3 > Copy B3 to B4: > B4: =SUM(SumRange) result 6 > > Introduce: > B3: =SUM(SumRange) result 3 > Introduce: > B4: =SUM(SumRange) result 6 > > Can this help? > /First a typo correction in my original post: > C2="=Arow" will resolve to "a1" should say > C2="=Arow" will resolve to "Arow" Also, my example was a bit confusing since I used the word "row" when I should have used "col" /
Thanks, but I'm afraid this doesnt do what I need. Your example doesnt use labels, just a named range. Maybe a lot of users isnt aware of this function? Here is a short description how label's work. Define the label range: Mark range A1:B1 Menu/Insert/Names/Labels: (make sure radiobutton "contains column labels" is selected) Accept the current range by pushing Add, then OK Set these cells: A1:="colA",B1="colB" *(note these cells contain pure text)* A2:=1,B2:=0.1,C2:="=colA" A3:=10,B3=0.01,C3:="=colB" *(note the = in front of the label name of C2 and C3)* C2 will now show the value 1 and C3 will show 0.01 *I need to be able to point the labels to the column above:* C2 should show "colA" (or "#REF!" if it's out of range) and C3 should show 0.1 (the row above) ..and I would like this to be possible with the suggested enhancement. -- View this message in context: http://nabble.documentfoundation.org/Calc-enhancement-request-Label-ranges-tp3809978p3818694.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
