The SUMIF function is a pre-defined function in Excel, Gives the SUM of cells in a range that meet one or more criteria. You can use SUMIF to SUM cells as per criteria , SUMIF support logical operators (>, <, <>, =) and partial match wildcards (*, ?).
Syntax
The syntax for SUMIF() looks like this:
=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
