how to use the sum function in google docs

How to use the Sum function in Google docs
Posted By Kyle M. Brown 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.

|







comments powered by Disqus

Tag : spreadsheet

Ask a question or provide an answer

Posted Q&A(2)


Name
Email
URL
Comment
 
 
 
 

Search Tags

windows 7   Facebook login   windows xp   ftp   Google calendar sync   homepage   clear cache   ie 7   pdf   shapes   animate   image search   map   resolution   windows xp   Internet   computer   screenshot   word   chrome   encryption   temp files   toolbar   temp files   FireFox   google define   portable air conditoner   Smartrip Card   image   analytics   real time search   google docs   Gmail   archive   Paypal   spreadsheet   GOOG 411   publisher   boot cd   decrypt   email   screen recorder   skype setup   spreadsheet   picassaweb   clear history   outlook setup   hard drive   search history   zip   auto-save   ip address   comcast   dvr   caller id   Live movie maker   Mobify   IE 8   google voice   app inventor   rss   converter   netmeeting   wordpress   google tv   google toolbar   ipad   Google ebook   bookmarks   IE 9   android   Safari 5   Facebook   Facebook login   KeepVid   PowerPoint   block calls   data recovery   angry birds   mac address   G2   photoshop   YouTube   clear history   xoom   Google Plus   FireFox 5   Google Translate   evernote   buffer   android development   HootSuite   uppidy   instagram   Google Drive   php and mysql   spreadsheet   Kojami   Excel to PDF   spreadsheet   Gmail Outlook 2010   Auto Archive Outlook   Outlook   Excel dashboards   Outlook   fitdivs   mailchimp   google-music   macbook-air   google-images   feedly   AirDisplay   outlook 2013   office-viewer   polaris-5   web-clipper   git   github   xfinity-wifi   automation

knowledge-base-software