Using the SUM Function


The most-used function, as you might expect, is the SUM function. If you're like most spreadsheet users, you'll find that well over half of your formulas involve totaling rows or columns of numbers. For this reason, Google has placed the SUM function in a prominent position in the Google Spreadsheets workspace, at the top right of the Formulas tab, alongside other popular functions. (Figure 37 shows these common functions in the Google Spreadsheets workspace.)

Figure 37. The SUM and other common functions.


To use the SUM function, follow these steps:

1.

Select the cell where you want the total to appear.

2.

Click the Sum link; this inserts =Sum( into the selected cell.

3.

Use your keyboard or mouse to select the range of cells you want totaled.

4.

Use your keyboard to enter the ) character to close the function argument.

5.

Press the Enter key.

Google Spreadsheets now calculates the formula and inserts the total for the selected range into the current cell.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net