sum hours assigned to a contact on a sheet for a particular month
Example: I have a project that lasts three months on a project sheet.
I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard
So for example: I need a formula that is going to Find all columns assigned to the contact "Timothy Lawrence" in August (Finish date column) and total those hours
Here is where I am getting stuck...
=SUMIF(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours])
This finds all of the hours worked by Timothy Lawrence on the sheet, however I can't seem to figure out how to narrow it down by the month.
The way I logic it out in my head is: "Sumif resource is Timothy Lawrence and finish date is month 8"
I have tried the formula below but get an Invalid data type:
=SUMIF(MONTH(8), AND(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours]))
Any thoughts? I'm stuck using the sheet template provided by the client (just adding formula rows to the bottom) so an actual re-write of the sheet isn't possible.
Help Article Resources
Check out the Formula Handbook template!