Vietnam.vn - Nền tảng quảng bá Việt Nam

Instructions on how to calculate sums in Word quickly and simply

Báo Quốc TếBáo Quốc Tế26/01/2024

Word is a popular editing tool that is frequently used in studying and working. In particular, calculating sums in Word is also of interest to many people because of its convenience and simplicity.
Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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.

Hướng dẫn cách tính tổng trong Word nhanh chóng, đơn giản

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)

No data
No data
Watch the sparkling Quy Nhon coastal city of Gia Lai at night
Image of terraced fields in Phu Tho, gently sloping, bright and beautiful like mirrors before the planting season
Z121 Factory is ready for the International Fireworks Final Night
Famous travel magazine praises Son Doong cave as 'the most magnificent on the planet'
Mysterious cave attracts Western tourists, likened to 'Phong Nha cave' in Thanh Hoa
Discover the poetic beauty of Vinh Hy Bay
How is the most expensive tea in Hanoi, priced at over 10 million VND/kg, processed?
Taste of the river region
Beautiful sunrise over the seas of Vietnam
The majestic cave arc in Tu Lan

Heritage

Figure

Business

No videos available

News

Political System

Local

Product