SUMIFS applies the region and date conditions to the same rows, then adds sales only where both pass. The live explanation identifies every contributing cell.
The DATE function in Excel is used to create a date by specifying the year, month, and day. It is helpful when you need to work with dates in Excel and want to construct a date value from individual components.
2026The year component of the date.1The month component of the date.1The day component of the date.Joins these values into a single piece of text.
">"">"DATE(2026,1,1)Sum values that meet multiple conditions at once with SUMIFS, Excel's multi-criteria addition function.
C2:C8The range of cells that you want to sum based on the provided criteria.A2:A8The range of cells to be evaluated by the first criterion."West"The criterion or condition to be met in Criteria_range1.B2:B8Additional range of cells for evaluating a second criterion.">"&DATE(2026,1,1)The criterion or condition to be met in Criteria_range2, and so on for additional ranges and criteria.Rows must belong to West and have a date later than January 1, 2026. C5, C7, and C8 contribute 1,600, 1,400, and 2,000 for a total of 5,000.
The rows above are ordered from the innermost calculation to the final result. Excel has to finish an inner function before the function around it can use that value. Edit a cell in the grid to see that dependency chain update for real.
The sample spreadsheet is fully editable. Change the formula or any cell it references. The intermediate values recalculate in your browser.
Here is an exercise that uses SUMIFS. Type the formula into a real spreadsheet and we will check your answer as you go.
Calculate total sales for a specific region AND specific product category.
Open exerciseIf this formula is not doing what you expect, one of these is usually why.
The dates may be text rather than real Excel dates, or the comparison operator may be missing. Build the cutoff with an expression such as ">"&DATE(2026,1,1).
The criterion uses >, which means strictly later than January 1. Use >= when the cutoff date itself should be included.
Yes. The sum range and every criteria range must cover corresponding rows with the same height.
Add the date range again with a second criterion, such as B2:B8,"<="&DATE(2026,3,31).