IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points
Which range does SUMIFS want first?
The situation
A regional total in the monthly pack is returning zero. The ranges are right and the region is spelled correctly, and the formula does not error — it just quietly reports nothing, which reads as a quiet month.
Functions in this exercise
- SUMIF — Adds up only the values that meet one condition. Syntax and example
- SUMIFS — Adds up values that meet several conditions at once. Syntax and example
Who this is for
Recommended next
Related exercises
- AdvancedData Analysis
Fix a SUMIFS with its arguments swapped
Repair a formula written in SUMIF's argument order instead of SUMIFS'.
SUMIFS
11 min35 points - IntermediateMath Functions
Total sales for a region and month with SUMIFS
Apply two conditions at once to a conditional sum.
SUMIFS
9 min25 points - BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points