SCENARIO
Let us understand the ysage and how to use the SUMIF formula as an example. Here is table given below we require to get the total of each indvidual seperately.
| Name | Amount |
| Peter | 15 |
| Paul | 20 |
| Paul | 30 |
| Peter | 15 |
Solution
In the excel sheet type the name of the individuals seperately as hown below:
Against of Peter in Cell E4 do as follow:
type =SUMIFS
Select values form Aount colum and click comma:
Then select values form name colum and click comma:
Then Select Column D4 and click enter button
Thus we will get value as shown below:
Continue the same procedure for (Paul) and you can see the result as shown below:
