IntermediateData Analysis3 min20 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.

SUMIFS takes the range to add last, exactly like SUMIF.
SUMIFS takes the range to add first, then criteria ranges and criteria in pairs.
SUMIFS takes the criteria first and the ranges afterwards.
The order does not matter — SUMIFS works out which range is which.

Functions in this exercise

SUMIF — Adds up only the values that meet one condition.
SUMIFS — Adds up values that meet several conditions at once.

Who this is for

Finance
Accounting
Business Analyst

Recommended next

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

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

Which range does SUMIFS want first?

The situation

Functions in this exercise

Who this is for

Recommended next

Total only the orders above average

Related exercises

Fix a SUMIFS with its arguments swapped

Total sales for a region and month with SUMIFS

Total sales for one region with SUMIF