Microsoft Office Tutorials and References

In Depth Information

**Creating formulas to calculate values**

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 refer to a table by entering 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 entering
=SU
. When you enter the letter
S
, Formula AutoComplete lists

functions that begin with the letter
S
; when you enter the letter
U
, Excel narrows the list down

to the functions that start with the letters
SU
.