What is the use of SUMIF in Excel?

Data Science, AI and ML
,
#1

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.

Syntax

=SUMIF (range, criteria, [sum_range])

Arguments

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