How this SUMIFS formula works
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 top row above is the whole formula. Open any argument that holds a calculation of
its own to see the values it used. Excel works out those inner parts first, because the
function around them needs their results. Edit a cell in the grid to see every value
update.
Try your own formula and data
The sample spreadsheet is fully editable. Change the formula or any cell it references.
The intermediate values recalculate in your browser.
Common mistakes with SUMIFS
If this formula is not doing what you expect, one of these is usually why.
Why is my SUMIFS with dates returning 0?
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).
Why does January 1 not count?
The criterion uses >, which means strictly later than January 1. Use >= when the cutoff date itself should be included.
Do SUMIFS ranges need the same size?
Yes. The sum range and every criteria range must cover corresponding rows with the same height.
How do I add an end date?
Add the date range again with a second criterion, such as B2:B8,"<="&DATE(2026,3,31).