I am stuck.
I am entering timesheet date into an excel sheet: Column A - Resource Name Column B - Project Phase Column C - Resource Team... Column D to AAA is a date Therefore a single resource could have multiple records as they work across multiple Project Phases and Resource terams.
I want to create a table that summarises total timesheet days by: Prolect Phase and Resource Group on the vertical axis and Month on the horizontal axis.
When I specify the sum range as $D$3:$AAA$100 I get a #value error, as it only wants a single row to be specified. I am using criteria to specify Project Phase and Resource Group and Month (as determined from the date.
Whilst it may be better to use a pivot table I also need to bring in budget data from another worksheet.