Tags: cell, excel, file, labels, microsoft, msdn, names, software, sum, values, worksheets

difference between cell names and cell labels

On Microsoft » Microsoft Excel

1,916 words with 2 Comments; publish: Thu, 22 May 2008 08:44:00 GMT; (30678.13, « »)

what's the difference and when would I use one over the other.

I want to sum values in different worksheets that are in the same file.

A2 is "loans active"

A3 is "current"

B1 is "Credit grade A"

C1 is "Credit Grade B"

Values are in B2:C3

Thanks.

All Comments

Leave a comment...

  • 2 Comments
    • For me anyway, a tad more explanation please

      What have you tried and what didn't work ?

      Steve

      On Fri, 26 Jan 2007 00:12:03 -0000, bobby769 =

      <bobby769.excel.questionfor.info.discussions.microsoft.com> wrote:

      > what's the difference and when would I use one over the other.

      > I want to sum values in different worksheets that are in the same file=.

      > A2 is "loans active"

      > A3 is "current"

      > B1 is "Credit grade A"

      > C1 is "Credit Grade B"

      > Values are in B2:C3

      > Thanks.

      #1; Thu, 22 May 2008 08:46:00 GMT
    • Bobby,

      A cell name is like A1 (unless you're using R1C1 notation). A range name,

      which can be one or more cells, is defined in Insert - Name - Define, or in

      the Name box at the left of the formula bar, and can be used in a formula in

      place of e.g.: A1 or A1:A20. Look in Help for Range Name.

      You can also use labels (on your sheet) such as column headings in formulas,

      but it's not reliable unless you follow some rules. I don't recommend it.

      YOu have to have "Accept labels in formulas" turned on in Tools - Options -

      Calculation.

      --

      Earl Kiosterud

      www.smokeylake.com

      ----

      "bobby769" <bobby769.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:023E8CB6-045B-4782-B767-E70C2E4DD0AB.excel.questionfor.info.microsoft.com...

      > what's the difference and when would I use one over the other.

      > I want to sum values in different worksheets that are in the same file.

      > A2 is "loans active"

      > A3 is "current"

      > B1 is "Credit grade A"

      > C1 is "Credit Grade B"

      > Values are in B2:C3

      > Thanks.

      #2; Thu, 22 May 2008 08:47:00 GMT