Sumif()

This formula helps you to sumup only those cell which you require based on near by column.

For ex: There is a messed data of sales.
You want total sales by sale agent xyz. This is where you can use this formula.

Formula:

Sumif(range, criteria, sumrange)

Where.
Range= Criteria Range. In the above example range containing agents name will be the criteria.

Criteria= Criteria or Condition. In the above example cell containing agents name for whom you want total sales(freeze it) or you can type the name manually in double quotes.

Sumrange= The range which you want to sumup. In the above example range containing sales numbers.