Excel SUMIF formula

Sum amounts or quantities only when a condition is met.

Una condizione: =SOMMA.SE(A:A;"Roma";B:B)
Più condizioni: =SOMMA.PIÙ.SE(C:C;A:A;"Roma";B:B;">100")

One condition: =SUMIF(A:A,"Rome",B:B)
Multiple conditions: =SUMIFS(C:C,A:A,"Rome",B:B,">100")

Example

Sums values in B:B only when A:A contains Rome.

Common error

In SUMIFS, the sum range comes before criteria ranges.

How it works

SUMIF is useful for totals by customer, city or product.

SUMIFS uses multiple conditions.

When should I use SUMIF?

With one condition.

When should I use SUMIFS?

With two or more criteria.