Excel Templates, Excel Add-ins, Excel Training and Business SoftwareExcel Templates - Excel Training - Excel Add-ins
Excel AutoSum

For Free 24/7 Microsoft Office� Support See:
Our Free Excel Help & VBA Help Forum.See Also our: Free Excel Newsletter


           SEARCH OZGRID

AutoSum

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

Excel Autosum. Sum up Values in Excel Automatically

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only $145.00. $59.95 Instant Buy/Download

Excel's AutoSum Function

Because adding numbers is probably the most common function that Excel is used for, Excel has a built-in Feature called AutoSum located on the Standard toolbar.  AutoSum is represented as the Greek Capital letter Sigma Σ.  You can use AutoSum to sum a range of cells.  A Range can be one single cell, or many cells.  You can sum cells in a contiguous (no gaps) range of cells, or a non-contiguous (cells not joined together) range.

To use AutoSum  you must click in the cell that you wish your result, or addition to appear in.  As a default, AutoSum looks up a column for figures immediately above it to add together.  This works great, unless it encounters a blank row or text.  If it does, then it stops at the last cell with a number in it.  If there are no numbers above it, AutoSum will automatically go to the left looking for numbers to add up, but will again stop at a blank column or text.   This is Excel's default, but you can easily change it.

The SUM Function is written as =SUM(number 1, number 2).  = is the trigger to Excel that a function or formula is following.  SUM is the name of the function and (number 1, number 2) are the arguments that the SUM function needs to work, or in our case the numbers it is to add up.  When you click the AutoSum icon, you will see the SUM function written in your cell, with a marquee (floating dotted line) around what the AutoSum intends to add up.  If the highlighted range is what you wanted to add up, click OK, if not then change the range you wish to add.

Following are three screen shots showing the AutoSum.

  1. AutoSum automatically picks up the numbers above it

  1. AutoSum automatically looks left for numbers if it encounters no numbers immediately above it.

  1. AutoSum automatically stops when it encounters a blank line, or text in the middle of the range it is trying to add up.

If you wish to change the range that the AutoSum is going to add, just highlight the range you want with your mouse.  If you want to add up a non-contiguous range, or cells that are not joined together, use your Ctrl key to mark the cells you do wish to add up.

Click here to go to Efficient Excel Spreadsheet Design


Our 4 Most Popular Bundled Savings!
1200 Excel Macros Save Over 70% time saving add-in for Microsoft Excel and two downloadable books on Excel macros Get the six most popular add-ins for Microsoft Excel and two downloadable books on Excel macros in one great collection.


Got any Excel Questions? Free Excel Help

Need help to complete a project?  Free Quote for Excel/VBA Programming & Consultancy


Software Categories Search Software

Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software || Outlook Add-ins

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

Contact Us