# Excell problem

Closed
Nate - Jan 15, 2010 at 09:58 PM
WutUp - Jan 16, 2010 at 12:27 PM
Hello,
How do you add cell values if they identical reference cells by using VLOOKUP.

Employee Supervsior Cust Handled Supervisor
1 A 100 A sup1
2 B 20 B sup2
3 A 30 C sup
4 C 45
5 B 60
6 A 70
7 B 80
8 C 90
9 A 100
10 B 40

How will i count the number of the customers handled of all employees under the same supervisor.

Been trying to create a formual for this but i just cant figure it out.

You can use the SUMIF formula. In your example, if you are wanting the sum of customers for supervisor A, then the total equals 300. The formula is =SUMIF(range,criteria,[sum_range]).
Where range = the supervisor column (or column B)
criteria = what is the exact value you want to sum (from column B - the range)
sum_range = what column do you want to sum (or column C)
Hope the example is clear enough.

Employee Supervisor Cust Handled Supervisor
1 A 100 A sup1
2 B 20 B sup2
3 A 30 C sup
4 C 45
5 B 60
6 A 70
7 B 80
8 C 90
9 A 100
10 B 40

A 300 =SUMIF(\$B\$2:\$B\$11,"A",\$C\$2:\$C\$11)
B 200 =SUMIF(\$B\$2:\$B\$11,"B",\$C\$2:\$C\$11)
C 135 =SUMIF(\$B\$2:\$B\$11,"C",\$C\$2:\$C\$11)