SUMIFS, COUNTIFS and friends

Level 1's SUMIF answers one question: revenue for the West. Real questions come with more filters than that. Revenue for the West, on the Pro plan, in May. That's what the IFS family is for.

=SUMIFS(E2:E13, B2:B13, "West", C2:C13, "Pro")

The column you're adding comes first. After it come pairs: a range to check, then the condition it has to meet. A row is added only when every pair matches. Add as many pairs as you need.

• SUMIFS adds.
• COUNTIFS counts. It has no sum range, just the pairs.
• AVERAGEIFS averages.
• MAXIFS and MINIFS find the biggest and smallest.

Conditions can do more than match text:

• ">=5000" keeps amounts of 5,000 or more. "<>Closed Lost" means not equal to.
• To compare against a cell, put the operator in quotes and join the cell with &: ">="&H2. Writing ">=H2" looks for the letters H2 and quietly counts nothing.
• A date window uses the same column twice: D2:D13, ">="&H1, D2:D13, "<="&H2 keeps everything from H1 to H2, both days included.

Watch the argument order. SUMIF puts the sum range last and SUMIFS puts it first. Plenty of analysts use SUMIFS even for a single condition, so there's only one order to remember.

Last habit: put the conditions in labeled cells (Region, Product, From, To) and point at them. Change a cell and every answer updates. That's most of what a dashboard is.