Sum with Multiple Conditions using SUMIFS

Add values that meet several conditions — the natural next step after SUMIF.

You will learn to

• Put the sum range first
• Add multiple criteria pairs

How it works

SUMIFS adds values that meet multiple criteria. Unlike SUMIF, the sum range comes first: =SUMIFS(E2:E8,B2:B8,"North",C2:C8,"Laptop").

=SUMIFS(E2:E8,B2:B8,"North",C2:C8,"Laptop")