How to write the wps summation formula

How to write the wps summation formula: 1. Add and sum, enter the numerical position to be added in the cell; 2. Use the function to sum, enter the formula "=SUM (parameter) in the cell "; 3. Alt =, select the blank cell below the number, and then press the shortcut key "Alt=", the sum of the numbers above the current cell will be automatically calculated.

The operating environment of this tutorial: windows10 system, WPS11.1.0.14309 version, DELL G3 computer

wps is our commonly used office The software covers a wide range of contents and is very easy to operate. For example, the sum of a large series of numbers can be calculated quickly using functions. There are many ways to sum. Today I will bring you a tutorial on how to write a WPS sum formula. I hope it will be helpful to you.

Add and sum

You can add and sum directly in the cell, as shown below, enter the value position to be added in the cell (cell Position);

Use function summation

The commonly used summation function is SUM(), enter the formula in the cell "=SUM(parameter)", where the parameter refers to the range of the required sum number;

Alt = shortcut key

Another way to sum is Use the shortcut keys to select the blank cell below the number, and then press the shortcut key "Alt=", it will automatically calculate the sum of the numbers above the current cell, try it now.

The above is the detailed content of How to write the wps summation formula. For more information, please follow other related articles on the PHP Chinese website!