Solved: Summing tasks for a Month period

[Hoopsah]

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

[Bob Phillips]

=SUMPRODUCT(--(MONTH(C2:C200)=1),--(YEAR(C2:C200)=2008),--(M2:M2:M200="some task),L2:L200)

[Hoopsah]

Hi Bob,

I keep forgetting about the SUMPRODUCT function, but once again this works perfectly,

Thanks again for your time

Cheers

Gerry