## Summary

To sum an entire column without providing a specific range, you can use the SUM function with a full column reference. In the example shown, the formula in F5 is:

``````=SUM(D:D)
``````

The result is the sum of all numbers in column D. As data is added to the table, the formula will continue to return a correct total.

## Generic formula

``=SUM(A:A)``

## Explanation

In this example, the goal is to return the total for an entire column in an Excel worksheet. One way to do this is to use a full column reference.

### Full column references

Excel supports "full column" like this:

``````=SUM(A:A) // sum all of column A
=SUM(C:C) // sum all of column C
=SUM(A:C) // sum all of columns A:C
``````

You can see how this works yourself by typing A:A or C:C into the name box (left of the formula bar) and hitting return. You will see Excel select the entire column.

### Example

To solve the problem in the example worksheet, we can use a full column reference to column D with the SUM function like this:

``````=SUM(D:D)
``````

The result is the sum of all numeric values in column D. One advantage to full column references is that they will automatically include new data. As entries are added to the table, the formula will automatically include the new amounts.