How to use excel sumifs function formula

How to use excel sumifs function formula: 1. Multi-condition parallel sum, the formula is [SUMIFS(D:D,A:A,"Company 1",B:B,"Personnel Department")] ;2. Sum by time period, the formula is [SUMIFS(C:C,A:A,">="&F2,A:A,"

Method used in excel sumifs function formula:

1. Sum of multiple conditions (parallel)

Requires statistics on the total salary of the Human Resources Department of Company 1

=SUMIFS(D:D,A:A,"Company 1",B:B,"Human Resources Department")

2. Sum of multiple conditions (or)

Requires statistics on the sum of salaries of the HR Department of Company 1 and the Finance Department of Company 2

= SUM(SUMIFS(D:D,A:A,{"Company 1";"Company 2"},B:B,{"Human Resources Department";"Finance Department"}))

3. Sum by time period

Requires statistics on the sales volume of product E from 2016-1-3 to 2016-1-4

= SUMIFS(C:C,A:A,">="&F2,A:A,"

4. Fuzzy condition summation

Required to calculate the sum of the quantities of products in column A that contain "TV" and the area in column B is Zhengzhou

Formula: C11

=SUMIFS(C2:C7,A2:A7,A11&"*",B2:B7,B11)

Note: Wildcards *

## can be used in sumifs

#5. Sum of multiple tables and multiple conditions

Vehicle sales details table No. 1~5

Requires summarizing each model in the summary table

=SUMPRODUCT(SUMIFS(INDIRECT(ROW(1:5)&"!c:c"),INDIRECT(ROW(1:5)&"!a:a "),A2,INDIRECT(ROW(1:5)&"!b:b"),B2))

##Related learning recommendations:

excel basic tutorial

The above is the detailed content of How to use excel sumifs function formula. For more information, please follow other related articles on the PHP Chinese website!