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.

3

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.