In this tutorial, we will see how to calculate sum of the values of a column. I have a tabular data like the following table.

To calculate sum for “Product A” column, place the cursor at the last cell of column 2 (cell marked in yellow color).

Press the “**Formula**” button (marked in red circle).

A “Formula” dialog box will appear.

There is some options you can choose from here. **=SUM(ABOVE)** will draw a sum of the values of upper cells. In “**Number format**” combo box, there are some options to control how the number will be formatted. From “**Paste function**” combo box, there are some predefined functions listed. Choose any function to take into account while calculating the formula.

Now press the “OK” button.

You get the total for **Product A** column. Repeat these steps to calculate sum for other columns.

**Caution**

Make sure that there is no **empty** cell in **any** cell of the column. Unless you won’t get the correct result. Put a “**Zero**” (0) in the cells which are empty.