## You are here

Home › sum# sum

## Summing It Up With Two Keys in MS Excel

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)

## Adding Times in MS Excel

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)

## Quickly Sum a Series of Numbers: MS Word

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)

## Use AutoSum: MS Excel

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)

## Most popular articles

- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10

**Do you need Tech Support?**

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.