Multiple SUMIF functions ?

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 employees
working on a number of various projects over a year.

The second part ( red ) is a summery of costs against jobs, using a
SUMIF function

The third, and tricky one is the last section (green) here i want to be
able to collate TOTAL hrs worked, per employee, dependant on the WEEK
NUMBER ( C40 ), irresecctive of which job(s) they have worked on - to
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 SUMIF
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.



Thanks

Attachment filename: book1.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=455705
---
Message posted from http://www.ExcelForum.com/