Excel formula to sum values in a range that meet specific criteria

In that case we can use the formula “Sumif” Let’s take an example to understand it, If I am having salesman names in column “A” and sales value of that salesman in column “B” then i can use this formula to get the total sales of each salesman.

=SUMIF(A:A,”Salesman Name”,B:B)