


Print article
Finding the Sum
Reader rating: 5 out of 10 Introduction 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.
Books on Microsoft Excel Featured articles Choosing a Cell Phone and Rate Plan  General Articles Stopping Unwanted Email  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 Copyright © 2003 Computertim Technologies. All rights reserved. 