Below are detailed instructions on how to quickly and easily calculate the total of vertical and horizontal columns in a World table. Let's take a look!
Calculate the total of vertical columns in Word.
To quickly calculate the vertical column sum in a World table, you can apply the formula using the Formula tool as instructed below:
Step 1: Click on the cell where you want to display the vertical column sum. Then, select the Layout tab from the menu bar.
Step 2: Next, select the icon labeled "Formula". A window will then appear where you can enter formulas and perform sum calculations in Word.
Step 3: In the formula window, there will be a cell for you to enter the formula. For this sum calculation, enter the formula “=SUM(ABOVE)” to get the sum of the vertical cells above the current cell in the table.
Step 4: Click the "OK" button after you have entered the formula. The result of calculating the sum in Word using the Formula will then appear in the cell you selected.
Calculate the horizontal sum in Word.
Similar to calculating the total of a column in Word, calculating by row also uses the Formula, as follows:
Step 1: Select the cell where you want to display the total for the entire row. Then, click the Layout tab in the menu bar.
Step 2: Next, click on the Formula box to start the calculation window.
Step 3: Here, enter “=SUM(LEFT)”. For example, as shown in the image, if you need to calculate the sum of male students from 6A1 to 6A4, you would sum the numbers on the left. If the cell you selected to sum is on the left side of the row in the table, enter “=SUM(RIGHT)”.
Step 4: After entering the formula, click "OK". Word will display the sum of the row.
Calculate the sum of multiple columns and rows in Word.
The method for calculating sums in Word with multiple rows or vertical columns in the table below will help you do it quickly and easily.
Step 1: Click on the cell where you want to get the total result and select Formula on the Layout tab.
Step 2: Next, enter: “=SUM(SUM(), SUM(), …, SUM())” to calculate the sum of multiple rows. Similarly, enter: “=SUM(SUM(), SUM(), …, SUM())“ to calculate the sum of multiple columns.
Step 3: Finally, click the OK button and you're done.
According to the formula above, you just need to replace , , ..., with the cell addresses of each row that you need to sum. As in the example in the illustration, you would enter “=SUM(SUM(B2:E2),SUM(B3:E3)). For calculating the sum in Word across multiple vertical columns, you replace , , ..., with the cell addresses in the table you need to sum.
The article above has guided you on how to calculate sums in Word using vertical columns, horizontal rows, multiple rows, and multiple columns. Hopefully, this information will help you use this word processing software more conveniently.
Source






Comment (0)