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.