Unlock the full potential of Excel's SUM function with advanced techniques for data analysis, conditional counting, and more.

How to Do the Sum of an Indefinite Series in Excel. The Microsoft Excel program includes a variety of mathematical formulas that you can apply to any cell in a spreadsheet.

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

Open your spreadsheet in Microsoft Excel. Click the cell where you wish the total sum to appear. Type "=SUM (range1,range2,range3)" into the cell and replace "range#" with a range of data.

Mac: The "Sum" function in spreadsheets is great, but if you're not the type to do all your list-making in Excel, coder Brett Terpstra built an OS X System Service that allows you to total up any ...