SUMIFS adds numeric values from rows that meet all supplied criteria. Start with a small example so that AND logic and range alignment remain easy to verify.
Identify the measure and conditions
Suppose amounts are in C2:C100, regions in A2:A100, and statuses in B2:B100. Use =SUMIFS(C2:C100,A2:A100,"West",B2:B100,"Paid") to total amounts for rows that are both West and Paid.
The sum range comes first. Each criterion range must describe the corresponding records. Keep headers outside the numeric measure and use consistent start and end rows.
Check the intended logic
Separate criteria arguments do not mean OR. A West unpaid row and an East paid row should both be excluded from this example. If your requirement is either of several categories, design that union separately and avoid counting overlapping groups twice.
Confirm the amount cells are numeric. Text amounts, duplicate transaction rows, or inconsistent status spelling can produce an incorrect total even when the formula’s syntax is valid.
Reconcile with known records
Create a short test containing a matching row, a row failing each individual condition, and an optional duplicate. Manually add the qualifying amounts and compare the result.
Review new-row inclusion after appending records. If criteria come from input cells, anchor shared criteria and source ranges appropriately when copying the formula. State units and period alongside the result so a valid sum is not mistaken for another measure. For date-based conditions, use actual date values and explicit boundaries rather than relying on an ambiguous display string to define the reporting period.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.