TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Quickly Sum Non-Contiguous Cells

There may be times when you want to calculate the sum of a group of non-contiguous cells. How do you do that now? Do you enter a formula such as =B5+D5+F5+H5+J5? That can be very cumbersome, especially if you're dealing with a lot of cells. That's how I used to it until I discovered a much faster and easier way.

Click the AutoSum button. Then, one at a time, click each of the cells you want to sum, typing a comma to separate each cell in the formula (i.e. =SUM(B5,D5,F5,H5,J5). So basically what you're doing is clicking the cells with your mouse and pressing the comma with your free hand. Even if you have many cells to sum, this way allows you do it very fast and easy.

Another option is to hold down the CTRL key (instead of pressing the comma) as you are selecting the cells.

You can also drag to select if there are some contiguous cells in your formula (i.e. =SUM(B5,D5,F5:H5,J5)

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window