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.

Four repair records include two closed jobs at East.

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.

Closing the East repair worth 20 changes the total to 95.

Illustrated status-change control.

Related Microsoft Excel reference