Computertim Technologies - free computer training, tips, and support

Home Articles Help Shop Business Education

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles

Microsoft Excel

Print article

 E-mail this page

Finding the Sum

Reader rating: 5 out of 10


While working in Excel, you may find it necessary to compute the total of a group of cells. You can do this with the Sum formula.

Finding the Sum

1. Click the cell you would like to display the sum in.

2. Type "=sum(cellname+cellname1)" (without the quotes). Substitute "cellname" and "cellname1" with the name of the cells you want to compute a total for (in this format: A1 + A5, or B5 + B3).

3. You can also find the sum for cells in an entire column. Use this formula: =sum(column:column). Substitute "column" with the letter of the column you want to find the sum of. (Example: =sum(c:c), =sum(a:a), etc.)

Note: If you compute the total for all the cells in a column, be sure not to place this formula in that column, otherwise you will not have an accurate total.

4. Once finished, press the "Enter" or "Return" key.

Rate this article:

Poor   1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10   Excellent

Books on Microsoft Excel

Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS

Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.

Home  |  Articles  |  Help  |  Shop  |  Business  |  Education  |  Contact Us

Privacy Policy

Copyright 2003 Computertim Technologies.  All rights reserved.