Related:
- Excell problem
- Excell download - Download - Spreadsheets
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)
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)
