sumif function

D

davidbrowne17

i am trying to combine 2 SUMIF fuctions to perform the following.

i have a list of employees, each has the following information.

WEEK NUMBER-- EMPLOYEE---JOB REF---Hrs worked

(each employee may work for a number of diffenent jobs over the sam
week)

i'm trying to collate total hrs worked for an employee, for all job
worked, based on a particular week number & employee. This is easy t
do by first filtering by WEEKNUMBER & then by EMPLOYEE. but is there
fuction that will do the same, and so each week we can print payslip
out for that week, to each emloyee totalling all hours worked?

=SUMIF(weeknumber,a1,hrsworked)
(gives me TOTAL HRS for ALL employees for week a1)

=SUMIF(employeelist,b1,hrs)
(gives me TOTAL HRS for al PARTICULAR employee, a1)

im after combining the 2 functions above, but have had no luck am
looking at this the wrong way??

Ta.

David:confused
 
B

Bob Phillips

David,

Try

=SUMPRODUCT((A1:A100=wknum)*(B1:B100=emp),(D1:D100))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

davidbrowne17

!!!! THANKS.

It works, although im still tring to evaluate how??.
better sleep on it and look again later.

Not looking over POOl Harbour, but wishing i was.

Dav
 
B

Bob Phillips

Dave,

Ken Wright gives a more than passable explanation at
http://tinyurl.com/3b868

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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