Multiple SUMIF functions ?

[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

 

[Frank Kabel]

Hi
enter the following formula in D42:
=SUMPRODUC(($B$6:$B$23=B42)*($A$6:$A$23=$C$40),$D$6:$D$23)
and copy down

 

[davidbrowne17]

Thanks!

i can now see it, 1x1x Hrs,
0x1x hrs
0x0x hrs etc.

good work