How to set up automatic summing in wps: first enter the formula [=SUMPRODUCT(A2:A7,B2:B7)] in any cell; then click the menu [Data] and click [Simulation Analysis], Enter [Solver]; finally click [Solve]. The sum of the corresponding numbers in column A that is actually 1 in column B is equal to 1,000.
To put it simply, summing means that if I know a target value, then I will choose which items from the data table to add together. The sum after getting up is exactly the target value. Today we are going to learn how to set up automatic summing in Excel. In the data below, which data can be added to get the target value of 1,000.
The first step is to enter the formula =[=SUMPRODUCT(A2:A7,B2:B7)] in any cell.
The second step is to click the menu [Data], click [Simulation Analysis], and enter [Solver].
The third step is to set [Set target], [Target value] and [By changing variable cells]. After completing the above settings, click [Add] Key setting [obey constraints].
The fourth step is to set the constraints as shown in the figure and click OK.
Finally, click [Solve]. The sum of the corresponding numbers in column A that is actually 1 in column B is equal to 1,000.
More tutorials:《php tutorial》
The above is the detailed content of How to set up automatic summing in wps. For more information, please follow other related articles on the PHP Chinese website!
