SUMIF will come useful when you have data and you need to find certain values. For example paying performance rewards, where you need to look at sales reports how much each person performed. In this example we have 3 names; distributor, salesperson, and vendor.
We are starting with coping with the data on „sheet 2“, removing the duplicates and the result is a list with unique values. Now when using SUMIF formula with our unique values as search value and our task is done. Simple and useful