Using SUMIF function in excel

The SUMIF Function takes 3 parameters

 

1. range: from where you are going to set your criteria

2. criteria: which elements you want to add/ what you want to add

3. sum_range: the numbers need for calculation  

	A	B
1	Sheuli	212
2	Sheuli	22
3	Shefali	5
4	Chameli	56
5

  In the above worksheet we have two columns. In one column names are given and another column the amonts belongs to them are given.

If we want to know the amounts belong to Sheuli, we can use a  SUMIFfunction


 

like this

	A	B
1	Sheuli	212
2	Sheuli	22
3	Shefali	5
4	Chameli	56
5		=SUMIF(A1:A4,"Sheuli",B1:B4)

hence, we will get the following result which belongs to Sheuli, 222 & 22 is 234

	A	B
1	Sheuli	212
2	Sheuli	22
3	Shefali	5
4	Chameli	56
5		234