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
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