Excell problem

[Closed]
Report
-
 WutUp -
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.

1 reply

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)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!