The WPS table uses the SUMIF function to filter after the summation sales achievement

Source: Internet
Author: User
Tags first row sumif function

In the financial data statistics, sometimes to filter the sum of some or special conditions, such as the sum of the bonus of the same person's name in the payroll, or the sum of the sales of the product in the table, the summation is not appropriate, a MO to introduce to you if using the SUMIF function to complete the sum.

The SUMIF function refers to a sum of several cells, ranges, or references based on a specified condition, with the syntax =sumif (range,criteria,sum_range). Where range is a conditional region; Criteria is the summation condition; Sum_range is the actual summation area. When Sum_range is not used, the condition area is the actual summation area. The following Mo is explained by a simple example.

In the previous table, the number of sales for each sales employee was recorded by date in March. To see the total sales of each employee in March, you can calculate the total sales for each salesperson in the WPS Mobile version using the SUMIF function.

First figure out the total sales of Rok Zhang Xinsen in March, the method is to double-click the F3 cell in the WPS mobile version, select the "T" icon in the upper-left corner of the virtual keyboard, click the "F (X)" button, and select the "SUMIF" function under "common functions" in the list of functions.

Next, enter =SUMIF (B3:B22,E3,C3:C22) in the function format bar of the WPS Mobile built-in keyboard, where 3 of B3 and C3 in the function represent the first row of the list of people in the table, and 22 in B22 and C22 represent the last row. Make sure the input is correct and then click the Return key, at this point Mo See, sales staff rok Zhang Xinsen March total sales of 14593.

Slide your fingers to the left. WPS Mobile version of the menu navigation bar, find the "Fill" button, click and select "Drag Fill", when a mo with a finger down the virtual arrow, the table of the other 4 sales staff of the total sales volume is also automatically calculated.

Mo believes that for the financial staff proficient in data statistics, it is not difficult to understand the basic concepts of SUMIF functions. Hope that through a case of Mo above to explain, can help "rookie" learn SUMIF function of the use of methods.

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: and provide relevant evidence. A staff member will contact you within 5 working days.