What is the use of SUMIF in Excel?

The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

  • Purpose: Sum numbers in a range that meet supplied criteria
  • Return value: The sum of values supplied.


=SUMIF (range, criteria, [sum_range])


  • range - Range to apply criteria to.
  • criteria - Criteria to apply.
  • sum_range - [optional] Range to sum. If omitted, cells in range are summed.