There might be times when you wish to find out the sum of a range of numbers quickly without having to add a formula to the Worksheet. For these instances, we can simply use the AutoCalculate feature of Excel.
To do this, select a range of cells containing the numbers you want to sum and look in the Status bar. If the Status bar is not visible go to View>Status bar. If the range of cells you wish to sum are non-adjoining, hold down the Ctrl key while selecting the ranges.
We are not restricted to only displaying the sum of our selected range! If you right click on the Status bar a shortcut menu will pop-up allowing us to choose one of six basic formulas. Have a look at each of these in turn and if you are unsure of what they do, please ask.
Go To Free Excel Training Lesson 21 . Back to Previous Lesson
Go to Excel Basic/Level 1 Training Index
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates