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

The SUM function is probably the most basic function you need in Excel. Walter Hickey BI You type in =SUM( and then select an array of values.

Quickly sum rows and columns in Microsoft Excel with the AutoSum feature. Getty Enter a formula or use the AutoSum feature to total all values in a row in Excel.