Excel Sumif

SUMIF is used to sum values in a range that meet the specified criteria.

Syntax:
SUMIF(range, criteria, [sum_range])

Description:

• Range : the range of cells to be evaluated.
• Criteria : numbers or text that determine which cells to add
• Sum_range : if you want to add cells other than those specified in the range argument

Example:

Place your cursor on A7 cell.

To sum the discount that the price above $20 type:

 =SUMIF(A2:A5,">20",B2:B5)

And then press enter. The result like that.

Happy Trying,,