Hoopsah
08-26-2008, 06:52 AM
Hi
I have a spreadsheet that lists the sum of tasks undertaken by some employees.
the tasks don't change, nor does the list of employees.
Each week, each employee submits a timesheet and I collate all of this into 1 sheet.
Column C has the date that the task was carried out. Column M has the title of the task and Column L holds how many times the task was done on that specific date.
What I would like is a formula that will be able to give me the monthly totals for the tasks - the date is held as 01/01/01 (dd/mm/yy)
so ideally, it would look at the month (The middle 01) and then sum all the tasks for each employee.
Hope this makes sense,
cheers for any help
Hoopsah
I have a spreadsheet that lists the sum of tasks undertaken by some employees.
the tasks don't change, nor does the list of employees.
Each week, each employee submits a timesheet and I collate all of this into 1 sheet.
Column C has the date that the task was carried out. Column M has the title of the task and Column L holds how many times the task was done on that specific date.
What I would like is a formula that will be able to give me the monthly totals for the tasks - the date is held as 01/01/01 (dd/mm/yy)
so ideally, it would look at the month (The middle 01) and then sum all the tasks for each employee.
Hope this makes sense,
cheers for any help
Hoopsah