Below are details on how to quickly and easily calculate the total of vertical and horizontal columns in the World table. Follow along!
Calculate vertical column sum in Word
To quickly calculate the total of vertical columns in the World table, you can apply the formula using the Formula tool according to the instructions below:
Step 1: Click on the cell that needs to display the vertical column total. Next, select the Layout tab on the menu bar.
Step 2: Then, select the icon with the word Formula. At this time, the window to enter the formula and calculate the sum in Word will appear.
Step 3: In the formula window, there will be a cell for you to enter the formula. With this method of calculating the total, you enter the formula “=SUM(ABOVE)” to give the result of the sum of the vertical cells above the table of the current cell.
Step 4: Click the “OK” button after you have entered the complete formula. Then, the result of calculating the sum in Word using Formula will appear in the cell you selected.
Calculate horizontal sum in Word
Similar to the way to calculate the total of vertical columns in Word, calculating by row will also use the Formula, details as follows:
Step 1: Click on the cell where you want to display the total result of the entire row. Then, click on the Layout tab on the menu bar.
Step 2: Next, click on the Formula box to start opening the calculation window.
Step 3: Here, you enter “=SUM(LEFT)”. For example, in the picture, you need to calculate the total number of male students from 6A1 to 6A4, you perform the sum function of the numbers on the left. If the cell you choose to calculate the total is on the left side of the row in the table, enter “=SUM(RIGHT)”.
Step 4: After entering the formula, click “OK”. Word software will display the total result of the row.
Calculate the sum of multiple columns and rows in Word
How to calculate the total in word with multiple rows or columns in the table below will help you do it quickly and simply.
Step 1: Click on the cell where you need to get the total result and select Formula on the Layout tab.
Step 2: Then, you enter: “=SUM(SUM(), SUM(), …, SUM())” to calculate the total of multiple rows. Similarly, you enter: “=SUM(SUM(), SUM(), …, SUM())“ to calculate the total of multiple columns.
Step 3: Finally, click the OK button and finish.
According to the above formula, you just need to replace , , …, with the cell addresses of each row that you need to calculate the sum. As in the example in the illustration, you will enter “=SUM(SUM(B2:E2),SUM(B3:E3)). For calculating the sum in Word according to multiple vertical columns, you replace , , …, with each cell address in the table that you need to calculate the sum.
The above article has guided you how to calculate the total in Word by vertical column, horizontal row, multiple rows, multiple columns. Hopefully the above information will help you more conveniently when using this editing software.
Source
Comment (0)