Count with Multiple Conditions using COUNTIFS

Count rows that meet two or more conditions at once.

You will learn to

• Pair criteria ranges with criteria
• Count rows meeting all conditions

How it works

COUNTIFS takes pairs of ranges and criteria and counts rows where every condition is true: =COUNTIFS(B2:B8,"North",C2:C8,"Laptop").

=COUNTIFS(B2:B8,"North",C2:C8,"Laptop")