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.

How to calculate sum of column values

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

How to calculate sum of column values
 
Press the “Formula” button (marked in red circle).

 

A “Formula” dialog box will appear.

How to calculate sum of column values

 

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.

Other articles of this category:

There is no article found in this category.

I Recommend RamNode VPS Hosting

high performance ssd vps