When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

PivotTable enables us to create various tables by changing its fields on each area as a kind of interactive table. With PivotTable, we can analyze and process complex data tables quickly. Take this raw data sheet as an example, which displays the sales of each branch of a brand. Now we can start to analyze its data. For example, we can analyze the total sales of each branch, the total sales of each item sold in each branch, the total sales of each item sold in each branch in each sales....

When working with data tables, especially when the data is referenced multiple times, we can find potential errors by tracing dependents. Take this worksheet as an example. The net profit in the table is calculated from the total amount of sales minus the cost of purchases. Normally, it is difficult to detect if the figures are misquoted.If we want to check whether the total sales are correct, we can select the sales price in cell F8, head to the Formulas tab, and click the Trace Dep....

We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.First of all, insert a total column on the right of the table,select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in thi....