There are a number of ways to insert a SUM() function into an Excel spreadsheet. The hard way is to enter the entire function manually. That method is prone to mistakes because you must know the cell references and then enter them correctly. If you like, you can enter =SUM( manually, highlight the range to avoid incorrect cell references, enter the closing ), and then press Enter. That method eliminates the problem with cell references, but it still requires a lot of steps. There are two easier ways to sum values:
- Highlight the row or column, plus one blank cell for the result, and press [Alt]++.
- Highlight the row or column, plus one blank cell for the result and click AutoSum on the Standard toolbar.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.