Excel SUMIFS function — sum with several conditions

SUMIFS adds the rows that meet all conditions — for example Aysel's sales in Bakı.

In other languages: ÇOKETOPLA (Türkçe), СУММЕСЛИМН (Русский)

Syntax

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

Arguments

sum_range: The range to add (unlike SUMIF, it comes first).
criteria_range1: The range for the first condition.
criteria1: The first condition.
criteria_range2: Further range–condition pairs (up to 127).

Example

Find Aysel's total sales in Bakı.

ABC

1CityManagerSales

2BakıAysel120

3BakıMurad90

4GəncəAysel60

5BakıAysel40

Type the formula in C6

The formula in your Excel

English Excel=SUMIFS(C2:C5,A2:A5,"Bakı",B2:B5,"Aysel")
Türkçe Excel=ÇOKETOPLA(C2:C5;A2:A5;"Bakı";B2:B5;"Aysel")
Русский Excel=СУММЕСЛИМН(C2:C5;A2:A5;"Bakı";B2:B5;"Aysel")

The result is 160 (120 + 40).

✨ Have the AI explain this formula

Useful tips

For a date range use two conditions: ">="&F1 and "<="&G1.
All conditions must be true at once (AND logic).

Common errors

#VALUE! — the ranges do not have the same number of rows.