Summing Up All the Values in a Column

Hi, Im unable to find the answer to my query as it only seems to relate to Excel 2003 (and doesn't work when I apply it to 2013). So with the below in mind, can you tell me how I can sum up on-going values in a column without having to re-calculate the total cell each time a new row is inserted please? Thanks.
------------------------------------

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated