SUMIF is a powerful function that allows you to sum values in a range based on a specific condition. It's perfect for sales reports, budget analysis, and any situation where you need to sum values that meet certain criteria.

SUMIF Syntax

=SUMIF(range, criteria, [sum_range])

Parameters:

• range: The range of cells to evaluate against the criteria
• criteria: The condition that determines which cells to sum
• sum_range: Optional. The cells to sum. If omitted, the cells in range are summed

SUMIF Examples

Example 1: Sum Sales by Product

Sum all sales for "Product A":

=SUMIF(A2:A10, "Product A", B2:B10)

Example 2: Sum Values Greater Than Threshold

Sum all values greater than 100:

=SUMIF(A2:A10, ">100")

Example 3: Sum by Date Range

Sum sales in January:

=SUMIF(A2:A10, ">=2026-01-01", B2:B10)

Example 4: SUMIF with Wildcards

Sum all products starting with "Pro":

=SUMIF(A2:A10, "Pro*", B2:B10)

SUMIF vs SUMIFS

SUMIF handles one condition, while SUMIFS can handle multiple conditions. Use SUMIFS when you need to sum based on multiple criteria.

Conclusion

SUMIF is essential for conditional summing in spreadsheets. Master it to create powerful reports and analyses in Excel, LibreOffice Calc, and Google Sheets.