Microsoft Office Professional 2010 Step by Step eBook

As an example, consider a worksheet that contains a two-column Excel table named

Exceptions. The first column is labeled Route; the second is labeled Count.

You can reference and entire column in a formula by using the column name.

You refer to a table by typing the table name, followed by the column or row name in

square brackets. For example, the table reference Exceptions[Count] would refer to the

Count column in the Exceptions table.

To create a formula that finds the total number of exceptions by using the SUM function,

you begin by typing =SU. When you type the letter S, Formula AutoComplete lists

functions that begin with the letter S; when you type the letter U, Excel narrows the

list down to the functions that start with the letters SU.

Creating Formulas to Calculate Values 289