Selecting the range for Auto SUM.
Because there are no values located in the cells above or to the left of cell B5, Auto SUM will not auto select a range of cells to use with the function. We will have to do it ourselves.
Using Auto SUM this way is very similar to typing in the SUM function the way we did in step 1. The advantage of using Auto SUM in this situation is that we don't have to do any typing as you will see.
Note: refer to the image at the top of the page for help on these steps.
- Select cell B5.
- Click on the Auto SUM button on the standard toolbar.
- Use the mouse pointer to drag select cells B13 to D13.
- Press the ENTER key on the keyboard.
