How to use the Sum function in Google docs
Posted By quikStarts March 14, 2011 09:08 pm List ViewGrid View

This guide is part of the Google Docs series

Guides in this series:

1. Auto fit column width in Google docs spreadsheets
2. Change a date in a Google doc spreadsheet cell
3. Change the hyperlink color in a docs document
4. Change the slide speed in Google Docs presentation
5. Convert Google docs spreadsheet into a PDF file
6. Convert Google docs spreadsheet into an Excel file
7. Freeze top row when scrolling in Google Docs
8. How to add a column to a google docs spreadsheet
9. How to add a URL to a Google doc document
10. How to add a URL to a Google doc spreadsheet




Make: Google

Model / Product: Docs

Version: Spreadsheet

Objective / Info: Use the Sum function to calculate the sum of the values of multiple cells in a column.


1
Launch Google Docs by visiting google.com, click the "more" menu option and select "Documents"
2
Click the spreadsheet that contains a column that you want to change.
3
Click to highlight the cell that will contain the sum.

  Note : In this example we create a cell and placed the word total in it and will populate the Sum next to it.

4
Click the "Function" button in the upper right hand corner.

5
Click "SUM" from the drop down menu.

6
The cell you selected to contain the sum should show some text now but not the actual sum.

7
Click and drag your mouse across all the cells that contain the values you would like to sum.

  Note : Capture cells in the column above the cell that you elected to contain the cell.

8
Press the "Enter" key on the keyboard and the sum of all of the selected cells should be reflected in the cell.

9
This task should now be complete. If not, review and repeat the steps as needed. Submit any questions using the section at the bottom of this page.

|

Tag : spreadsheet

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment
 
 
 
 

Search Categories

  • Mobile Phone
  • Software
  • Internet
  • Programming
  • General
  • Travel
  • Home and Garden
  • ISP
  • Hardware
  • Mobile App