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

Adding two or more cells in excel

Sometimes you may need to add two or more cells together in excel. for example, you want to add name and surname of people from your table given below .
Now in column C, I want to get them together as a title of Name-Surname. the formula is =A1&A2. through this you will get result is ChompaChameli, SheuliShefali ... If you want to leave a space between name & surname this time you have to use the formula =A1&" "&A2 and you will get the result like Chompa Chameli, Sheuli Shefali......
you can see the result of using the formula for the given table here.