SUMIFS and COUNTIFS: several rules

Add or count using two or more rules at once.

What if you want to know how many notebooks were sold in the South? That's two rules at once. For this there are the versions with an S at the end:

Module: Counting and adding with rules. Lesson 20 of 62.

• Previous lesson: AVERAGEIF: average only what matters
• Next lesson: VLOOKUP: look up a value in a table
• All lessons