Enter Site, Status and Cost in A1:C1. Use four rows: East / Closed / 45, East / Open / 20, West / Closed / 90 and East / Closed / 30.
Put the amount range first
=SUMIFS(C2:C5,A2:A5,"East",B2:B5,"Closed")The closed West job fails the site check, and the open East job fails the status check. Add 45 and 30 by hand and expect 75.

Illustrated inclusion test. Each qualifying row matches both criteria.
Change one label in a working copy
Mark the East repair costing 20 Closed and expect 95. If the total includes a neighboring record, check that every range covers rows 2–5 and that amounts are numeric. Use criteria cells if the report owner should be able to change the site or status.

Illustrated status-change control.



