Quickly Sum Non-Contiguous Cells
by Francis Hayes (The Excel Addict)
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 =B7+D7+F7+H7 ?
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.
1) Click the AutoSum
button on the Home tab (or press ALT
+ =);
2) Next, press and hold down the
CTRL key;
3) One at a time, click each of
the cells you want to include in your SUM while still holding
down the CTRL key. Even if you have many cells to sum, this
way allows you do it very fast and easy. If there are some contiguous
cells you want to include in your formula, you can also drag to select those
(i.e. =SUM(B7,D7:F7:H7);
4) Finally, press ENTER to
complete your SUM formula.
If you found this tip helpful, please share it with your friends and colleagues.
To get more tips every week like this one...
'Spreadsheet Tips From An Excel Addict'
'Excel in Seconds' & 'Excel in Minutes'
Plus you also get my 'Excel in Seconds' E-book as a BONUS!
(Download it immediately after you sign up)
Copyright Francis Hayes © All Rights Reserved
8 Lexington Place, Conception Bay South, NL Canada A1X 6A2
Phone 709-834-4630
This site is not affiliated with Microsoft Corporation.