
* Calculation in a Table *
⇨ How to Calculate Total?
a) At first create a Table.
b) Move the cursor at total cell.

c) Click on Layout Tab.
d) Click on Formula from Data group.

e) Select function from Paste Function combo box. By default there will be =SUM(LEFT). This function is for Addition. You can change the function as your need.

f) Click on OK.

g) Then select the Total value and right click on it and click on copy.

h) After that you have to select the other cells. Then click on paste.

f) You will see the same value on the other cells as we did copy paste. Then we have to update the cells to get the correct result.
Press F3 Key from the keyboard to update.

a) At first create a Table.
b) Move the cursor at total cell.

c) Click on Layout Tab.
d) Click on Formula from Data group.

e) Select function from Paste Function combo box. By default there will be =SUM(LEFT). This function is for Addition. You can change the function as your need.

f) Click on OK.

g) Then select the Total value and right click on it and click on copy.

h) After that you have to select the other cells. Then click on paste.

f) You will see the same value on the other cells as we did copy paste. Then we have to update the cells to get the correct result.
Press F3 Key from the keyboard to update.
