Microsoft Office Tutorials and References
In Depth Information
Creating formulas to calculate values
To add the SUM function (followed by an opening parenthesis) to the formula, click
SUM and then press Tab. To begin adding the table reference, enter the letter E . Excel
displays a list of available functions, tables, and named ranges that start with the
letter E . Click Exceptions, and press Tab to add the table reference to the formula. Then,
because you want to summarize the values in the table’s Count column, enter a left
square bracket and then, in the list of available table items, click Count. To finish
creating the formula, enter a right square bracket followed by a closing parenthesis to create
the formula =SUM(Exceptions[Count]) .
If you want to include a series of contiguous cells in a formula, but you haven’t defined the
cells as a named range, you can click the first cell in the range and drag to the last cell. If
the cells aren’t contiguous, hold down the Ctrl key and select all of the cells to be included.
In both cases, when you release the mouse button, the references of the cells you selected
appear in the formula.
TIP Excel highlights each cell range used in a formula in one of several colors.
In addition to using the Ctrl key to add cells to a selection, you can expand a selection by
using a wide range of keyboard shortcuts.