Formulas & functions

# SUMIFS

Use SUMIFS to test multiple conditions and return a value based on those conditions. For example, you could use SUMIFS to sum the number of a products sold by a certain salesperson.

## Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• =SUMIFS(A3:A10,B3:B:10,B13,C3:C10,A13)

• Sum the values in the cell A3 to A10 for the rows where the value in B3 to B10 is B13, and the value in C3 to C10 is A13.

## Steps

1. Select a cell.

2. Type =SUMIFS, and a left parenthesis (.

3. Select the sum range, and type a comma.

4. Select the first criteria range, and type a comma.

5. Select the criteria, and type a comma.

6. Select the second criteria range, and type a comma.

7. Select the criteria, and type a comma.

8. Press Enter.

## Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions