Hi,

I have a spreadsheet where I enter hours worked for employees. Some
employees work more than one department. After entering the hours and
departments, I have a pivot table that summarizes everything by (1) employee,
and (2) department. This works well.

Next, I have a data file that I use to import the info into ADP's PayExpert
payroll software. The data file uses sumif formulas to summarize each
employee's hours. It sums hours based on employee number. The problem is, I
need to figure out how to summarize the hours for the multiple department
employees by each department for each employee. For example, below is what
it's doing now:

Employee Temp. Dept. Hours O/T
Hours Mileage
100 23
$12.00
101 40
3.5 $0
102 35
$0
104 32
$9.60

In the above example, assuming employees 100 and 104 worked multiple
departments, what I need to do is have the hours and mileage summarized for
each department worked. Example:

Employee Temp. Dept. Hours O/T
Hours Mileage
100 15
$6.00
100 412623 8
$6.00
101 40
3.5 $0
102 35
$0
104 16
$2.80
104 416206 8
$2.80
104 416225 8
$4.00

Some other things to consider: Not all multiple department employees work
the same departments each week. There are more than 50 departments, and
almost every employee can possibly work at least 8-10 of 30 departments each
week.

Is this possible?

Thanks in advance!