Using Labels in Excel Formulas and Functions

Summary of the Steps

1. Make sure the Accept labels in formulas option is turned on.
   
   
2. Enter the label headings.
   
   
3. Enter the data under or to the right of the labels.
   
   
4. Enter the formulas or functions using labels, to indicate the data to include in the function or formula.

• Simplify Your Excel 2003 Formulas
• "Accept Labels in Formulas" Option Must Be Activated
• Add Data to the Cells
• Add a Function to the Worksheet
• Summary of Steps for Using Labels in Excel Formulas and Functions