Excel’s SUM function doesn’t natively handle array criteria within curly brackets as expected. Instead, try using SUMPRODUCT or SUMIFS with multiple criteria. The issue likely arises from implicit intersection rules. Double-entering forces array evaluation, but a structured approach with SUMPRODUCT avoids this workaround.