Excel Question

[89emily]

I have three columns

I have employees in column A
I have a series of departments in column B
In column C there is a count of how many appointments that each employee has (which is derived from a different area)

ie
column a - john, bob, sam, ted
column b - admin, it, admin, accounts
column c - 5, 1, 3, 2

I want to create another table that displays how many appointments each department has. eg admin has 8 - IT has 1 - accounts has 2

So the way I think of it would be if b? = 'admin' then count c? but not sure how to translate it in excel as I am not that experienced in excel.

 

[p45cal]

Pivot table shaded green or formulae in B17:B19 (just paste B17 and copy down)

Excel Workbook
	A	B	C
1	Emp	dept	appt count
2	john	admin	5
3	bob	it	1
4	sam	admin	3
5	ted	accounts	2
6
7
8
9	Row Labels	Sum of appt count
10	accounts	2
11	admin	8
12	it	1
13	Grand Total	11
14
15
16	dept	appts count
17	admin	8
18	it	1
19	accounts	2
Sheet12

 

[Just Jan]

=SUMIF(B:B,"admin",C:C)
=SUMIF(B:B,"IT",C:C)
=SUMIF(B:B,"accounts",C:C)

 

[89emily]

Just what I was after. Thanks for the prompt assistance!