Multiple SUMIF functions ?

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top