1. Computing

Using Labels in Excel Formulas and Functions

By

4 of 5

Add a Function to the Worksheet
Formula using a label in Excel spreadsheet

Formula using a label in Excel spreadsheet

© Ted French

Type the following function in cell B10

=SUM(Numbers)

and press the ENTER key on the keyboard.

The answer 100 will be present in cell B10.

Note - Labels are not case sensitive in Excel formulas. It does not matter whether you type Numbers or numbers as the label in the formula.

©2014 About.com. All rights reserved.