SUMIFS with multiple criteria in Excel

Two text criteria

The first argument is what to add, here the amounts in D. Then come the conditions, each as a range and a criteria. Rows are only added when every condition matches.

Text plus a number condition

Put the comparison operator in quotes with the number. You can even use the sum range as a criteria range, as here, to only add amounts of 450 or more.

Criteria from a cell

Point a criteria at a cell (G2) so you can switch the region from a dropdown without editing the formula. For comparisons, join the operator and the cell: ">="&H2.

OR logic: add SUMIFS together

SUMIFS has no built-in OR. For "East sales of laptops or docks", write one SUMIFS per product and add them. A row can only be one product, so nothing is double-counted.

Not equal, wildcards and between

"<>North" means any region except North. Wildcards work too: "Mon*" matches Monitor. For a band of values, use the same column twice with ">=" and "<=". This one totals mid-size sales between 300 and 1,000.

Build a summary table, or pick another tool

SUMIFS shines in a summary grid. List regions down a column and products across a row, then write one formula with mixed references and copy it across the grid. For a grid with regions in F2:F4 and products in G1:I1, the formula in G2 would be =SUMIFS($D$2:$D$9,$A$2:$A$9,$F2,$B$2:$B$9,G$1).

Lock the data ranges with $ so they never move, lock the column of the region label and the row of the product label, and every cell picks up the right pair. When your data grows, convert it to a table (Ctrl+T) and use structured references so the ranges grow too.

Use SUMIFS for AND conditions on plain columns; it is the fastest and the easiest to read. Use SUMPRODUCT when you need OR across different columns or a calculation inside the condition, such as matching on the month of a date. Use a PivotTable (Insert > PivotTable) when you want totals for every combination at once and do not need the numbers inside other formulas.