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.
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.