Microsoft Office Tutorials and References

In Depth Information

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, type 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, type a left square bracket and then, in the list of

available table items, click Count. To finish creating the formula, type a right square bracket

followed by a right 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.