Add up values that meet two or more criteria at once using SUMIFS.
Copy this formula
=SUMIFS(C:C, A:A, "East", B:B, ">100")SUMIFS sums the values in the first range (the sum range) only for rows where every criteria range matches its criterion. Here it totals column C where column A is "East" AND column B is greater than 100. Add more range/criteria pairs to layer on conditions.
=SUMIFS(Sales, Region, "East", Month, "Jan")→4,200Total Jan sales for the East region only.
Single condition
=SUMIF(A:A, "East", C:C)Use SUMIF when you only have one condition.
SUMIF handles a single condition; SUMIFS handles multiple conditions. In SUMIFS the sum range comes first, while in SUMIF it comes last.
Yes — use two criteria on the date column, e.g. =SUMIFS(C:C, D:D, ">="&DATE(2026,1,1), D:D, "<="&DATE(2026,1,31)).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.