Related:

- Excell problem
- Excell download - Download - Spreadsheets

## 1 response

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)