What is SUMIF?
SUMIF is a spreadsheet function that adds up the values in a range that meet one condition, such as all sales in the North region or every invoice over $1,000.
SUMIF syntax
It checks each cell in range against criteria and adds the cells that match:
SUMIF(range, criteria, [sum_range])
If sum_range is given, it adds the cells in the same rows of sum_range instead of range itself.
A SUMIF example
With regions in A2:A200 and sales in C2:C200:
- =SUMIF(A2:A200, "North", C2:C200) adds all North sales.
- =SUMIF(C2:C200, ">1000") adds every sale over 1,000.
SUMIF with text criteria and wildcards
Text criteria are not case-sensitive, and wildcards widen them: "North*" matches North and Northeast, and "?ast" matches East and Past. To compare with a value in another cell, join it to the operator, as in ">"&E1.
SUMIF vs SUMIFS
SUMIF takes one condition; SUMIFS takes several and puts the sum range first: SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, …). For a SUMIF date range, such as sales between two dates, you need two conditions, so SUMIFS is the right tool where it is available. Arkenso Docs supports SUMIF among its 60-plus functions.
Last reviewed 2026-11-01.