# 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.
Related:

## 1 response

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)