Hi

I have a sheet of data that is laid out by person in column A, task in column B then daily dates across the rest of the columns from 1/9 to 31/12.

There are several people and several tasks.

What I want to be able to do is summerise the monthly data in a seperate tab by person and month.

I've tried some SUMIFS and INDEX/MATCH, but can't see an easy way to get all the variables in.

Can anyone please help with this?

thanks