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

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!