Calculate Q1 revenue by region
You're building a quarterly revenue report. You need to sum all revenue for the "East" region where the month number is in Q1 (≤ 3).
Calculate Q1 revenue by region
Practice using SUMIFS to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
You're building a quarterly revenue report. You need to sum all revenue for the "East" region where the month number is in Q1 (≤ 3).
Write a SUMIFS formula that sums column D (Revenue) where column B (Region) is "East" and column C (Month) is less than or equal to 3.
SUMIFS extends SUMIF to multiple conditions, all of which must be true for a row to be counted. You give it the sum range first, then pairs of criteria range and criterion. The standard way to answer 'how much did East region sell in Q3?' in one formula.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)Try the formula first. Hints cost CP for a reason.