SUMIF

Intermediate

Math & Calculation

Adds cells that meet a specific condition or criteria. Perfect for conditional sum calculations.

Syntax
=SUMIF(range, criteria, [sum_range])
Parameters
range
Required
(range)

Range of cells to evaluate against criteria

criteria
Required
(text | number | expression)

Condition that determines which cells to sum

sum_range(range)

Actual cells to sum (if different from range)

Examples
Real-world examples to help you understand how to use SUMIF

Sum values greater than 100

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

Sums only cells in A1:A10 that are greater than 100

Result: Sum of values > 100

Sum based on text criteria

=SUMIF(B1:B10, "Apples", C1:C10)

Sums C1:C10 where B1:B10 contains "Apples"

Result: Sum of apple sales

Sum with cell reference

=SUMIF(A1:A10, ">"&B1)

Sums values greater than the value in B1

Result: Conditional sum

Common Use Cases
  • ✓Sum sales for specific products
  • ✓Calculate total expenses by category
  • ✓Sum values above or below threshold
  • ✓Aggregate data based on criteria
  • ✓Financial reporting with conditions
Pro Tips
  • 💡Use wildcards (* and ?) for partial matches
  • 💡Criteria can include comparison operators
  • 💡sum_range must be same size as range
  • 💡Enclose text criteria in quotes
Common Errors
  • ⚠️Mismatched range sizes
  • ⚠️Forgetting quotes around text criteria
  • ⚠️Using wrong comparison operators
Related Formulas
SUMSUMIFSCOUNTIFAVERAGEIF

Need a Custom SUMIF Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula