=SUMIF(range,criteria,sum_range)

=SUMIF(range containing comparable data,Cell to extract data,Range containing Amounts/Quanities)

SUMIF is Formulla in Excel for DATA Analysis.SUMIF used  along with IF formulla can provide the results beyond your imagination.

SUMIF formulla is mostly used to find the Total of a selected Object out of given Objects; Confused or Bounced well lets do some practical.

Suppose your company has announced a scheme that who buys for more than 250 will be given a Gift, below is an example of just 5 buyers but if you have lakhs of buyers it really beocomes difficult to find out total quantities sold to each Buyer. So we will use SUMIF formulla here.

 Buyers(A8:A25) Quantity(B8:B25) Amar 23 Akbar 3435 Anthony 46 Ram 565 Shyam 466 Geeta 57 Sheeta 67 Anthony 6 Ram 876 Shyam 98 Geeta 79 Sheeta 9 Amar 98 Akbar 0 Anthony 435 Ram 54 Shyam 543 Geeta 53

 Buyer Name(A28) Total Quantity Sold Total Quantity Sold Anthony 487 =SUMIF(A8:A25,A28,B8:B25)

You can see that using the formulla you have to just replace the name of Buyer in column A30, and you will get the total quantities sold to that Buyer.

Well this was just a simple example, now we will try to combine the SUMIF formulla with IF formulla.

In above example we only get the total quantities, suppose your boss want only whether Gift is to be given or not. Than we can use IF formulla to fulfill this requirement.

So you can observe that by combining the SUMIF formulla with IF formulla we got the required results.

Exercise

If you understood it than try to use it, and find

How much Shyam has bought and Does he deserve a Gift.

Posted 4 years, 9 months ago by CA Pulkit Sharma

thanks pulkit for sharing this is very useful for all

Posted 3 years, 8 months ago by sunita thapa

Thank you Sunita.
You can also help other by sharing your knowledge with others on this site.
To thank me, please start a discussion :)

Posted 3 years, 8 months ago by CA Pulkit Sharma

You need to be logged in to reply.