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.
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.