Show description

And if that isn’t enough to stir the pot, you can use three types of cell references: relative, absolute, and mixed. Okay, one step at a time here. Try out a formula that uses a range. Formulas that use ranges often have a function in the formula, so use the SUM function here: 1. Enter some numbers in many cells going down one column. 2. Click in another cell where you want the result to appear. 3. Enter =SUM( to start the function. 4. Click the first cell that has an entered value, hold the left mouse button down, and drag the mouse pointer over all the cells that have values.

This is like musical chairs! qxp 32 12/26/06 7:54 PM Page 32 Part I: Putting the Fun in Functions RefEdit controls Figure 1-22: Getting ready to enter some arguments to the function. More argument entry boxes appear as you need them. First, though, how do you enter the argument? There are two ways. 7. Enter the argument one of two ways: • Type the numbers or cell references into the boxes. • Use those funny-looking squares to the right of the entry boxes. In Figure 1-22 two entry boxes are ready to go.

Enter some numbers in many cells going down one column. 2. Click in another cell where you want the result to appear. 3. Enter =SUM( to start the function. 4. Click the first cell that has an entered value, hold the left mouse button down, and drag the mouse pointer over all the cells that have values. 5. Release the mouse button. The range address appears where the formula and function are being entered. 6. Enter a ). 7. Press Enter. 8. Give yourself a pat on the back. Wherever you drag the mouse to enter the range address into a function, you can also just type in the address of the range, if you know what it is.