Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 49

4 Click the Collapse Dialog button next to the number1 argument.

5 Drag your mouse pointer over the range B2:B11.

6 Click the Restore Dialog button.

The cell range B2:B11 is entered into the number1 argument. See

Figure 2-10.

7 Click OK.

The total gasoline sales value of $87,047 is now displayed in cell B13. You

can easily add total sales for other individual products and for all products

together using the same Autofi ll technique used earlier.

To add the remaining total sales calculations:

1 Select B13.

2 Click the fi ll handle and drag it to cell D13.

3 Release the mouse button.

Total sales figures are now shown in the range B13:D13. See

Figure 2-11.

cells used

to calculate

gasoline sales

Figure 2-10
Adding
arguments
to the SUM
function