Subtotaling on more than 1 criteria

[elb1999]

Trying to count the number of employees in deparments, that roll up into cost centers, then get the count of the employees in the cost center

 

[schielrn]

Can you maybe post a screenshot of your data or better explain what columns are used and how this data is laid out? You would either need to use a variation of sumproduct(), but would need data to put into the formula or do a search for sumproduct on the board.

 

[elb1999]

Data is laid out in columns, with column A being the employee, various other employee info in other columns. The 2 column I wish to count and sum are cost center and department. Every employee is in a cost center, so that column is populated for each employee. If a cost center has multiple departments then the dept column will be populated. If a cost center doesn't have departments the department column will not be populated. I want to count the # of employees in the departments, then roll up of count of the employees in the related cost center, as well as counting employees in cost centers without departments

 

[schielrn]

Here is a basic example since you did not provide much detail:

Note that ranges cannot be whole columns and must be of same size.

Book1
	A	B	C	D
1	Name	CostCenter	Dept	Amount
2	Name1	934854775	Dept1	9.5
3	Name2	934854775	Dept2	3.36
4	Name3	934854775	Dept2	5.62
5	Name4	934854775	Dept2	1.39
6	Name5	984577443	Dept2	9.39
7	Name6	984577443	Dept3	7.96
8	Name7	984577443	Dept3	8.35
9	Name8	984577443	Dept2	5.39
10	Name9	984577443	Dept3	6.28
11	Name10	984577443	Dept3	8.77
12	Name11	945684583		5.86
13	Name12	945645645		6.79
14	Name13	964565645		8.39
15	Name14	964565645		4.55
16	Name15	964565645		3.38
Sheet3

Book1
	G	H	I	J
1	CostCenter	Dept	CountofEmployees	Sum
2	934854775	Dept1	1	9.5
3	934854775	Dept2	3	10.37
4	984577443	Dept2	2	14.78
5	984577443	Dept3	4	31.36
6	945684583		1	5.86
7	945645645		1	6.79
8	964565645		3	16.32
Sheet3

Hope that heps.