The application of sumifs function in Execl2010

This function solves the problem that needs to be summed in multiple conditions and expands the function of the SUMIF function. For example: You need to calculate the sales of Beijing potato chips.

Operation method

1, the selected cell, input function, the format of the SUMIFS function is: sumifs (sum_range,criteria_range1,criteria1[criteria_range2,criteria2] ...)

2. "Sum_range" indicates the range of data that needs to be summed. The range of data you need to select in this example is "G5:g16".

3, "Criteria_range1" indicates the scope of the condition 1, in this case the choice of criteria range is the "City" column, that is, "b5:b16."

4, "criteria1" means 1, in this case 1 for the "City is Beijing", "Beijing" said.

5, "criteria_range2" means the scope of the condition 2, in this case 2 of the scope of the "Product" column, "C5:C16" said; Criteria2 "means 2, in this case 2 is" the product is potato chips ", expressed in" potato chips ".

6, the final results of Beijing potato chip sales, as shown in the following figure.