Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between cell names and cell labels
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between cell names and cell labels
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 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between cell names and cell labels
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
How do I sort multiple names within one cell? | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions |