Add up cells that meet multiple conditions at once.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)SUMIFS totals values that satisfy every criterion you supply — for example, sales in the East region during Q1 above $500. Note the sum range comes first, then each criteria range/criteria pair.
=SUMIFS(C2:C100, B2:B100, "East", D2:D100, ">500")Result: $31,200
Sums sales where region is East AND amount exceeds 500.
Yes — use two conditions on the date column, e.g. ">="&start and "<="&end, to sum within a window.