Overview The Power of excel is in the math and the performing of calculation, Adding ranges of cells is easy when you use Auto Sum. Adding cells that are not adjacent to one another is also a snap with the use of your mouse, Simply begin the formula with an equal sign, as with any function in Excel, and click on the cells you wish to total.