How to sum quickly in a WPS table

Source: Internet
Author: User

Box selected A.b.c.d four lattice, after the selection, with the mouse cursor to find the toolbar sum button "∑", click and appear in D lattice. This is the sum of the lines, the same, in the column summation also according to this method operation: Box select 1,2,3,4 ... Finally leave a space, press the sum button will result.

Add: In your box selection, the status bar in the table (bottom line) will have you box selection of the "sum" hint: The format is: sum =?

The use of the automatic sum button is more convenient, if you do not use this method, you will be using the sum formula, is more troublesome. You need to enter formulas in the formula bar or cell: The format is: =a#+b#+c# ... (where the # number is the number of cases).

Quadrature is not automatic, you must enter the formula, such as: =a#*b#*c# ..., (where # is the number of cases).

For example, let's say: you want to ask A1 to A20 and, you can first box A1 to A21, press the Sum button, and then no matter what you enter A1 to A20 these 20 cells in what values, in the A21 cell will automatically appear their sum. This is the sum of the column, the same in the line, I do not say more.

What if the requested and not in a row (or column)? That is the radio requirements and the cell, such as A1 B2 C3 D4 operation method is: First select A1, hold down the CTRL key, select B2, the same in the C3 D4 the final cursor placed in the requirements and results of the space, press the sum button ∑ can be.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.