Using Sum Formula in Excel

=Sum("A:A")
The formula above will give you the total value of column A (e.g in the case that you have sales figures in column A). It will display this value.

Read More..