Add up the cells that meet a single condition.
SUMIF works the same in Google Sheets. For multi-condition or SQL-style aggregation, QUERY is a powerful Sheets-native alternative.
SUMIF(range, criteria, [sum_range])SUMIF totals values that match one criterion — for example, all sales for a single region. The criteria range and the sum range can differ. For more than one condition, use SUMIFS.
=SUMIF(B2:B100, "East", C2:C100)Result: $42,300
Sums column C where the region in column B is East.
=SUMIF(C2:C100, ">1000")Result: $88,500
Adds all values greater than 1000.
SUMIF handles one condition; SUMIFS handles multiple. SUMIFS also puts the sum range first, so the argument order differs.