Use the SUMIFS function with DATE so the formula works reliably regardless of your system's regional date format: ```excel =SUMIFS(C2:C7, A2:A7, "East", B2:B7, ">=" & DATE(2026, 1, 1)) ``` How It Evaluates Row 2 (East, 2025-12-15, 400): Excluded (date is before January 1, 2026) Row 3 (West, 2026-01-05, 250): Excluded (region is not East) Row 4 (East, 2026-01-10, 300): Included (300) Row 5 (East, 2026-02-01, 540): Included (540) Row 6 (West, 2026-02-03, 610): Excluded (region is not East) Row 7 (East, 2026-03-12, 400): Included (400) Result: 1,240 (300+540+400)