Microsoft Office Tutorials and References
In Depth Information
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 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 .