Hi,
I've been banging my head against a wall with this and I'm reaching out to the internet for some wisdom and help.
I have a basic spreadsheet that shows a request for the cover of hours which is then either then picked up by Group 1, Group 2 or Group 3.
What I need to do is show in the report a summary of the requests for hours covered in each four weekly period along with the hours that are/were outstanding. I originally tried a pivot table which I can do for a single date range but I understand it isn't possible to show multiple date ranges in one pivot table, the use of multiple pivot tables isn't practical as I have a number of areas that I need to duplicate the below for.
I've tried COUNTIFS and IF statements referencing the start and end date periods in column A and B but I just can't get it to work, although I suspect its a three stage formula - if a date between column A and B and in e.g. group 1 then count hours in hours column. It also needs count the entire column in the data tab, the data tab is formated into a table (called Table1 for reference).
Many thanks for any help.
Report Tab
Data Tab
I've been banging my head against a wall with this and I'm reaching out to the internet for some wisdom and help.
I have a basic spreadsheet that shows a request for the cover of hours which is then either then picked up by Group 1, Group 2 or Group 3.
What I need to do is show in the report a summary of the requests for hours covered in each four weekly period along with the hours that are/were outstanding. I originally tried a pivot table which I can do for a single date range but I understand it isn't possible to show multiple date ranges in one pivot table, the use of multiple pivot tables isn't practical as I have a number of areas that I need to duplicate the below for.
I've tried COUNTIFS and IF statements referencing the start and end date periods in column A and B but I just can't get it to work, although I suspect its a three stage formula - if a date between column A and B and in e.g. group 1 then count hours in hours column. It also needs count the entire column in the data tab, the data tab is formated into a table (called Table1 for reference).
Many thanks for any help.
Report Tab
Data Tab