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 .