ExcelBanter - What does label do under Insert, Name, Label?

Hi

Using existing row and column labels as names

When you create a formula that refers to data in a worksheet, you can use
the column and row labels in the worksheet to refer to the data. For example,
to calculate the total value for the Product column, use the formula
=SUM(Product).

Using a label

Or if you need to refer to the Product 3 amount for the East division (that
is, the value 110.00), you can use the formula =Product 3 East. The space in
the formula between "Product 3" and "East" is the intersection operator. This
operator designates that Microsoft Excel should find and return the value in
the cell at the intersection of the row labeled East and the column labeled
Product 3.

Note By default, Excel does not recognize labels in formulas. To use labels
in formulas, click Options on the Tools menu, and then click the Calculation
tab. Under Workbook options, select the Accept labels in formulas check box.

Stacked labels When you use labels for the columns and rows on your
worksheet, you can use those labels to create formulas that refer to data on
the worksheet. If your worksheet contains stacked column labels€” in which a
label in one cell is followed by one or more labels below it€” you can use the
stacked labels in formulas to refer to data on the worksheet. For example, if
the label West is in cell E5 and the label Projected is in cell E6, the
formula =SUM(West Projected) returns the total value for the West Projected
column.

The order for stacked labels When you refer to information by using
stacked labels, you refer to the information in the order in which the labels
appear, from top to bottom. If the label West is in cell F5 and the label
Actual is in cell F6, you can refer to the actual figures for West by using
West Actual in a formula. For example, to calculate the average of the actual
figures for West, use the formula =AVERAGE(West Actual).

Using dates as labels When you label a range by using the Label Ranges
dialog box and the range contains a year or date as a label, Excel defines
the date as a label by placing single quotation marks around the label when
you type the label in a formula. For example, suppose your worksheet contains
the labels 2007 and 2008 and you have specified these labels by using the
Label Ranges dialog box. When you type the formula =SUM(2008), Excel
automatically updates the formula to =SUM('2008').

Challa Prabhu

"trainer07" wrote:

What does label do under Insert Name Label? Will you please give me an
example?
Thanks!