use of Sumif

 USE OF SUMIF

This is the Fantastic formula of excel and this formula is use for when we have the data in bulk and we have to find out the sum of the same product

For example-  We have a data and we have to find that how much Quantity sold of one product.

So Here is the Example.

Range required. The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. For Example The Column of Product as Shown in Example.

Criteria required. Criteria is that select the product that you want to sum.

 As shown in the Example select the Mango

    sum range: The actual cells to add, if you want to add cells other than those specified in the range argument. For Example the column of Quantity.

If you want to find that all prroct how much Quantity has been Sold so just Copy the 
Formula in another Cell you will get the how much Quantity of another produch Sold.