Quickly sum non-contiguous cells

Sometimes you may want to calculate the sum of a group of non-continuous or non-contiguous cells.  Do you enter in each cell address like =A2+C2+G2+I2?  That can take a lot of time, if you have to add many cells.

Click the AutoSum button ?. Then click on each of the cells which you want to add, and ensure that you type in a comma to separate each cell in the formula.  So this turns out to be fast as you are clicking the cells with the mouse and pressing the comma with your other hand. So an example is =Sum(A2,C2,G2,I2)

Alternatively, you can hold down the CTRL key as you are selecting the individual cells.  You do not have to press the comma in this case.

If there are some contiguous cells in your formula, you can also drag to select them.  For e.g =sum(A2,B2:D2,H2).

Picture below shows the Autosum option in 2007 under the Home Menu.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube