Fill in the formula field with "SUM (A:A)" and replace "A:A" with the indefinite range you want to total. For example, if you wanted to find the total of all the data in column C, you would enter ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula?