D
davidbrowne17
now here is a tester for you all.
the attached worksheet lists WEEK, EMPLOYEE, JOB, HRS.
The first part of the sheet ( blue) is added to weekly, with employee
working on a number of various projects over a year.
The second part ( red ) is a summery of costs against jobs, using
SUMIF function
The third, and tricky one is the last section (green) here i want to b
able to collate TOTAL hrs worked, per employee, dependant on the WEE
NUMBER ( C40 ), irresecctive of which job(s) they have worked on - t
issue to our payline company.
i have tried nesting SUMIF functions, and SUMPRODUCT - but had no luck
the only answer i can see is to do this across 2 tables - one to SUMI
WEEK NUMBERS, and then to a second table to SUMIF by EMPLOYEE.
is there a slicker way to look at this i'm not seeing?
David.
London.
(e-mail address removed)
Thank
Attachment filename: book1.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=45570
the attached worksheet lists WEEK, EMPLOYEE, JOB, HRS.
The first part of the sheet ( blue) is added to weekly, with employee
working on a number of various projects over a year.
The second part ( red ) is a summery of costs against jobs, using
SUMIF function
The third, and tricky one is the last section (green) here i want to b
able to collate TOTAL hrs worked, per employee, dependant on the WEE
NUMBER ( C40 ), irresecctive of which job(s) they have worked on - t
issue to our payline company.
i have tried nesting SUMIF functions, and SUMPRODUCT - but had no luck
the only answer i can see is to do this across 2 tables - one to SUMI
WEEK NUMBERS, and then to a second table to SUMIF by EMPLOYEE.
is there a slicker way to look at this i'm not seeing?
David.
London.
(e-mail address removed)
Thank
Attachment filename: book1.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=45570