SUMIF Function (OpenOffice Calc)

• Adds values that meet a single condition
• Supports numeric, text, and logical criteria
• Works with ranges of any size
• Allows comparison operators (>, <, >=, <>, etc.)
• Supports wildcard matching (* and ?)
• Works across sheets
• Ignores empty cells automatically

SUMIF is optimized for fast conditional aggregation and is widely used in financial models, inventory sheets, and categorized datasets.

SUMIF(range; criteria; sum_range)

Arguments:

• range — The cells to evaluate against the condition
• criteria — The condition to test (text, number, or expression)
• sum_range — The cells to sum when the condition is met

Sum values greater than a number

=SUMIF(A1:A10; ">50"; B1:B10)

Adds values in B1:B10 where the corresponding value in A1:A10 is greater than 50.

Sum values equal to text

=SUMIF(A1:A10; "North"; B1:B10)

Adds values in B1:B10 where A1:A10 equals "North".

Sum values matching a wildcard

=SUMIF(A1:A10; "Jan*"; B1:B10)

Matches any text beginning with “Jan”.

Sum values in the same range

=SUMIF(A1:A10; ">0")

Sums all positive numbers in A1:A10.

Sum values across sheets

=SUMIF(Sheet1.A1:A100; ">100"; Sheet1.B1:B100)

Sum values using cell‑based criteria

=SUMIF(A1:A10; C1; B1:B10)

If C1 contains ">=500", the formula uses that condition.

Sum values not equal to something

=SUMIF(A1:A10; "<>North"; B1:B10)

Sum values with partial text match

=SUMIF(A1:A10; "*Service*"; B1:B10)

Matches any text containing “Service”.

Sum values using numeric comparisons

=SUMIF(A1:A10; "<=100"; B1:B10)

Sum values with dates

=SUMIF(A1:A10; ">=" & DATE(2025;1;1); B1:B10)

• Keep range and sum_range the same size
• Use cell references for criteria to make formulas dynamic
• Use wildcards for flexible text matching
• Avoid mixing text and numbers in the same column
• Use SUMIFS when multiple conditions are required
• Use named ranges for cleaner formulas