sum

Most of you are familiar with the AutoSum feature in MS Excel and find it very handy indeed. All you have to do is click that icon on your toolbar and bingo! your formula for the sum of a data range is located just above whatever cell you have ... selected. I know that there are lots of folks out there like me who prefer to use the keyboard as much as they can because we like fewer keystrokes and saving time! So if you are one of those folks, here is another quick and easy way to sum in MS Excel.Select the cell below your column of data Then simply click ALT + = (Alt, plus the equal sign). Ta-da ... (view more)

You can add times in MS Excel using the =SUM worksheet function. All you have to do is enter all of your times as HH:MM:SS, and then use SUM to add them. You may omit the :SS if you like. By default, Excel will display the sum of times in ... time-of-day format, such that adding 12:30 + 12:45 will give you a total of 01:15. You can prevent MS Excel from rolling over at twenty-four hours by formatting the total cell as [h] :SUM, which will cause the total to display as 25:15 rather than 01:15. Another way of adding times is to use the TIME function. Follow along below: To add 2 hours, 30 minutes ... (view more)

There are plenty of tools you can rely on to perform sophisticated or complex calculations, but MS Word offers a command that can be handy when you just need to sum a few numbers without opening another software application. The command is Tools | ... Calculate, and although it doesn't appear on any toolbars, it's very easy to add. Choose Tools | Customize (or double-click an empty spot on any tool bar) to open the Customize dialog box. Click the Commands tab and choose All Commands from the Categories list box. Click in the Commands list box and scroll down to select ToolsCalculate Drag the ... (view more)

Suppose your Excel worksheet has a long list of numbers to add. You can sum them instantly using Excel's AutoSum feature. Don't count on your fingers or pull out a calculator; Excel can calculate more quickly and accurately. Even more importantly, ... whenever a number changes, Excel instantly recalculates and displays the corrected sum. You can use either of these two methods to total the numbers using Excel: Click the cell below the list to make it the active cell. Click the AutoSum button. Excel surrounds the cells it thinks you want to total with a moving border. Press Enter or click the ... (view more)