This video shows how to do simple math. Add together the cells in which you created the sums of the columns. MultiplicationTo multiply values use the operator.
In order to get the correct number format use the TEXT function and specify the number format that you want to display.
The Sum value will only display the sum of all selected cells. In our example we will sum together the numbers 5 and 3. The Excel FLOORMATH function will round a number down to the nearest integer or given multiple of significance. In the example data shown below rows 2 through 4 use a formula that is.