How to sum with multiple criteria (SUMIFS)
✓ Verified in LibreOffice 25.8.7.3Add up values only when several conditions are all true — e.g. sales for one region AND one product.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =SUMIFS(C2:C6,A2:A6,"East",B2:B6,"Widget") | Sum range first, then criteria pairs. Add more pairs for more conditions. |
| Google Sheets | =SUMIFS(C2:C6,A2:A6,"East",B2:B6,"Widget") | Identical. |
| LibreOffice Calc | =SUMIFS(C2:C6,A2:A6,"East",B2:B6,"Widget") | Identical. |
How it works
SUMIFS takes the sum range first, then any number of range/criteria pairs — a row is included only when every condition matches. Here only rows 2 and 6 are both "East" and "Widget", so the result is 10 + 50 = 60. Criteria accept comparisons (">100") and wildcards ("Widg*") too. Note the argument order differs from single-criterion SUMIF, where the sum range comes last.
Verified, not just documented
We ran =SUMIFS(C2:C6,A2:A6,"East",B2:B6,"Widget") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 60 — exactly the expected result. Every formula here is confirmed by actually executing it.